Skip to Content
avatar image
Former Member

SAP WEBI 4.0: Calculation between two measures only when at least one has values

Hey all!

I would like to ask for help dear Gurus!

Our problem is the following:

  • We are using SAP BPC Account dimension which provides us with the P&L accounts.
  • Then, we calculated two measures: [Year 2013] and [Year 2014] that give us the values for each P&L accounts for 2013 and 2014, respectively.
  • We want to calculate the growth rate for each P&L account from 2013 to 2014. For this purpose, we are now using the following formula: =([Year 2014]/[Year 2013])-1
  • This formula is OK, but when both measures are zero (i.e. when a certain account has no values for both 2013 and 2014), it still calculates being the result -100%...and this is wrong.
  • We would like to create a rule in the formula that gives a zero or blank value everytime when both measures are zero, or everytime when [Year 2013] is zero.

Is this possible?

Thank you very much for your attention.

Best regards,

Francisco

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 16, 2014 at 04:32 AM

    Hello Francisco,

    Try the below formula :-

    If ((isnull([Year 2013])) Or  ([Year 2013]=0);0;(([Year 2014]/[Year 2013])-1))

    Hope it helps !

    Regards,

    Tanb Gupta

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2014 at 11:09 AM

    Your Welcome 😊

    Keep Posting !

    Cheers 😀

    Add comment
    10|10000 characters needed characters exceeded