2 Replies Latest reply on Dec 29, 2018 1:57 PM by jon rios

    Create row level calculation using previous value

    jon rios

      i currently have a calc that creates a label based on a comparision between current value and previous value...i created a calc: previous value = Lookup(MIN( [value] ) ,-1)

       

      then in seperate calc i created: higher lower = if [value] >= [previous value] then 1, else 0 end.  but this produces an aggregtion because of the table calc in first calc.

       

      i was interested in a row level calculation that takes the row level value and looks to previous value then applies a label. so at the data source table you would see these labels for each row...there is a specific order to the data (date/time)

       

      i am struggling creating this "previous value" comparison at the row level... can anyone assist?  thanks