Cumulative quantities not showing

[Former Member]

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_member360228]

Hi,

As Arvind suggested, it should work for you. And for your other question of displaying 0 instead of blank, you can create a CKF and include your key-figure in it and then just add and subtract 1 from it e.g. *KF + 1 - 1 *

Regards,

Arminder

[Former Member]

hi,

Instead of creating structure you can see the cumulative values at a runtime only.

right click on the KF, properties > data cell> calculation tab -->check cumulative after applying single value.

Calculate single value -- sum

calculation direction -- calculate along row

tick apply detail calculation to result

Calculate result as -- Sum

tick calculation based on previous calculations.

this way the KF will show the cumulative values at runtime, you can save the view as global view and publish to users.

This has an advantage as this is easier to do rather than defining each cell in structure.

regards,

Arvind.

[Former Member]

Hi,

any updates?

Regards,

Joon