7 Replies Latest reply: Mar 1, 2016 9:12 AM by Fifi Nokoe RSS

    Variance Calculation in Script

    Fifi Nokoe

      Hello community,

       

      I'm trying to calculate the variance in the following script:

       

      =NUM(SUM(vCurrentDate) Amount - SUM(vPreviousDate) Amount) /  SUM(vPreviousDate) Amount

       

      Where vCurrentDate and vPreviousDate are variables.

       

      How would i calculate the variance in the script?

       

       

       

      Thanks.

       

      Fifi Nokoe