1 Reply Latest reply on Sep 10, 2015 12:06 PM by John Westbury

    Create calculated field for measure value in base period

    John Westbury

      Howdy

       

      I am trying to calculate a calculated field that captures a measure value in a base period.  The logic of what I am trying to do is create a calculated field (I'll call it baseEarnings) as: [Earnings] Where [Qtr Offset]=MIN[Qtr Offset].  The purpose of this field is to create a view that shows quarter by quarter growth/contraction measured as: ( [Earnings] - [baseEarnings] ) / [baseEarnings]. 


      The data I have looks something like:

       

      Qtr OffsetEarnings
      0100
      1110
      2120


      thanks


      John