Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Cumulative quantities not showing

Hi experts,

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.



Not what you were looking for? View more on this topic or Ask a question