I am calculating a running YTD total across 12 Months by picking up the last months calculated YTD value and adding a normal Hierarchy total. This I believe is not an out of the ordinary calculation. Here is the function restricted to "Total Income YTD" SEQUENCE("Periods", "Default", -1, ["Total Income YTD"]) + ["Total Income"]

Total income is a parent in the same dimension as Total Income YTD

I have tried both restriction on N levels and no restrictions both give the same result.

Where there are no values in a series of months the calculation is not working. It works correctly where there are balances in each month. In one instance one month was populated on its own and The YTD went for three months and then stopped. A subsquent value 3 months later gave that months YTD value but did not work for subsquent months.

In one instance I populated a value on one of the empty months and the YTD value calculated. I then removed the value but the YTD calculations continued correctly.

I have checked the memory utilistion on the saving of the rule from the logs and memory is not being exceeded.

Here it is working on a Profit center that is fully populated.

Here it is not working

Total income is a parent in the same dimension as Total Income YTD

I have tried both restriction on N levels and no restrictions both give the same result.

Where there are no values in a series of months the calculation is not working. It works correctly where there are balances in each month. In one instance one month was populated on its own and The YTD went for three months and then stopped. A subsquent value 3 months later gave that months YTD value but did not work for subsquent months.

In one instance I populated a value on one of the empty months and the YTD value calculated. I then removed the value but the YTD calculations continued correctly.

I have checked the memory utilistion on the saving of the rule from the logs and memory is not being exceeded.

Here it is working on a Profit center that is fully populated.

Here it is not working

Last edited:

Likes:
Ben Hill