3 Replies Latest reply: Aug 22, 2013 4:16 AM by Mirjam Ribeiro de Oliveira RSS

    Definitions Sales Difference and Sales Variance

      Can someone help me with these definitions? In the table, he gives a Sales Difference of 0 and a Sales Variance from 100%.

      What do I do wrong in the definitions?

       

      Sales Difference:

      ([Sales
      $(vMaxYear)]
      - [Sales
      $(vPriorYear)]
      )

       

      Sales Variance:

      If([Sales
      $(vPriorYear)]
      = 0,1,([Sales
      $(vMaxYear)]
      - [Sales
      $(vPriorYear)]
      ) / fabs([Sales
      $(vPriorYear)]
      ))
      //If statement needed for situation vPriorYear = 0
      //fabs statement needed for situation vPriorYear = negative

       

      Thanks in advance!

       

      Mirjam