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!