Skip to Content
0

Formula not working on Cumulated values

Apr 13 at 01:45 PM

17

avatar image

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 4 days ago
1

Hi,

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

https://wiki.scn.sap.com/wiki/display/BI/Cumulative+Value+Display

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

grtz

Koen


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