1 Reply Latest reply on May 15, 2018 2:31 AM by Steve Martin

    Calculated Field Using Blended Data

    ljubomir stajic

      Hi All,


      I'm having problems with a calculated field using blended data. I hope that somebody can help.


      The formula I'm trying to get to is:  (2018 Actual for March)/(2016 Actual for March)+1] *  PLAN (for June 2018)


      I got the ACTUAL 2018 growth but can't multiply it with the Plan amount.


      For federal, for example, it would be 100.4%*$175,091


      Thank you so much!