5 Replies Latest reply on Jul 21, 2019 2:27 PM by Hari Ankem

    Monthly, QTD, YTD totals using a date parameter

    John Thompson

      I need help with writing out the calculations to sum total sales by month based on a date parameter as well as a QTD and YTD totals based on the date parameter.

       

      The logic would be:

       

      Date parameter example 6/10/2019

      Month sales total would only include 6/1 thru 6/10

      QTD would include sales from 4/1 thru 6/10

      YTD would include sales from 1/1 thru 6/10

       

      Any suggestions would be greatly appreciated.

       

      Thanks