Cumulative quantities not showing
I have defined following structure in BEx query designer. The cumulative balance column is not displaying correct result.
The "cumulated" option has been selected for the formula "Cumulative Balance".
--- Debit | Credit | Monthly Balance | Cumulative Balance |
Jan | 100 | | 100 | 100 |
Feb | | | | |
Mar | 400 | | 400 | 400 |
I used to have correct data displayed when there are values for the whole year (from Jan to Dec). Hence, I suspect the problem lies on the unfilled rows (Feb in this example). Besides, I used to have a result row at the bottom of the structure as well!
1. Is there any solution to this problem?
2. How can I display zeros (0) instead of blank for the months without values?
3. How can I display a result row at the bottom of the structure?
Thanks in advance for your advice.