3 Replies Latest reply on Jan 11, 2017 6:48 AM by Dhruv Gupta

    How to calculate difference (growth) between MTD Sales and Previous MTD Sales

    Karolina Skvortsova

      I have 2 separate calculated fields:

      1. MTD Sales:

      IF [Day] <= TODAY()

      AND DATEDIFF('month',[Day],Today())= 0 THEN [Sales] END

       

      and

       

      2. Previous MTD Sales (the same period as MTD Sales but for previous year)

      IF [Day] <= [1 Year ago]

      AND [Day]>= [Datetrunc] THEN [Sales] END

       

       

      where field [1 Year ago] =DATEADD('year', -1, TODAY())

       

      and field [Datetrunc]  = DATETRUNC('month', DATEADD('year', -1, TODAY()))

       

      ??? How can I calculate percent difference between MTD Sales and Previous MTD Sales???