Skip to Content

Formula not working on Cumulated values

Apr 13 at 01:45 PM


avatar image
Former Member

Hi Experts,

Iam trying to calculate percentage of two key figures which are cumulated based on the calmonth through option available at local calculations in the bex query designer. Iam using formula for calculating the percentage. In formula instead of taking cumulated values calculation is executing for individual values.

Please let me know how can i calculate percentage on the cumulated values.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Apr 16 at 07:21 AM


Matthias Kadletz posted this link a week ago, please check it out.

note: you can't use the results of the local calculation like you experienced

I should use the third option - restriction of the month - start month till the current member - month

I tried it out myself and it worked perfectly



pwauv.png (12.1 kB)
10 |10000 characters needed characters left characters exceeded