3 Replies Latest reply on Jul 17, 2018 9:59 AM by Jon Boschee

    % Change

    Jon Boschee

      Hi everyone,

       

      I'm trying to do a % change calculation.

       

      Non-Aggregate

      Value 1 = 0.91

      Value 2 = 0.92

       

      Aggregate

      Value 3 = .01

       

      Calculation I'm trying to use but getting the Calculation contains errors: Cannot mix aggregate and non-aggregate arguments with this function.

       

      Value 3 / Value 1

       

      Should = 1.09%

       

      I'm tried making Value 1 an aggregate using sum and average but am not getting the right number back.

       

      Value 3 / sum(Value 1)

      and

      Value 3 / avg(Value 1)

       

      Anyone have any suggestions?