0 Replies Latest reply: Jul 19, 2017 2:19 PM by Rafal Niedzialek RSS

    Formula Help Growth Calc

    Rafal Niedzialek

      I have standard formula:

       

       

      =[$(=$(lTranslation(132,YOY $ vs FxLY)))]

      /[$(=$(lTranslation(65,FxLY Sales)))]

       

      which does the trick for positive growth but what if FxLY sales are negative and YOY positive?

       

       

      how would you write something like this:

       

      if FxLY is negative than calculate =(B1-B2)/ABS(B2) otherwise =[$(=$(lTranslation(132,YOY $ vs FxLY)))]/[$(=$(lTranslation(65,FxLY Sales)))]

       

      where B1 =[$(=$(lTranslation(132,YOY $ vs FxLY)))]

      and B2 = [$(=$(lTranslation(65,FxLY Sales)))]