SAP Analytics Cloud weird behaviour in table calculation

[bert_baeckelmans]

Hi everyone,

We are encountering some strange behaviour while using an in table calculation. See following visualization. Value 1 and Value 2 are measures which are already defined in BW. The other two columns are calculations created in SAP Analytics Cloud. In the 3rd column we divide value 2 by value 1. In the end it shows a total of 42.72%, which is correct.

In the last column we calculate the running total of value 2 and the running total of value 1 and as the other calculation we divide value 2 by value 1. So as a total we should also have 42.72%, yet this is not the case. And this is where the strange behaviour occurs. When we change something to the filter, or we do a small change in the table which has nothing to do with this total, this total will show correctly. Let's say I disable the totals and enable it again. Then it shows the correct result.

Anyone an idea what is happening? I have the feeling something underwater is not right.

Thank you in advance,

Kind Regards,

Bert