Skip to Content
avatar image
Former Member

Formula not working on Cumulated values

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 16 at 07:21 AM

    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

    Add comment
    10|10000 characters needed characters exceeded