Hi BI gurus,
We currently want to generate reports using BW, and in 0FIAP_C03, there are few different kind of Key figures.
If the user are asking for Amount (Paid Out/Balance).
These are the list of Key Figure available in the BW Reporting Cube:-
- Amount
- Cash discount amount
- Credit Amt in FC
- Credit amt in LC
- Debit amt in FC
- Debit amt in LC
- Debit/Credit Amount
- Discount Amt
- Discount base
Which key figure should we use to get Paid Out/Balance?
Or we can create Calculated Key Figures if formula involved.
Let us know which key figure or any formula to calculate using the key figure above?
Any advice is much appreciated.
Many thanks.