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 |

...

Dec

-


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.

Regards,

Joon

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