1 Reply Latest reply on Jul 18, 2017 6:19 AM by Kevin Warren

    Calculation - LOD Calc for previous month sum(sales)

    Kevin Warren



      I am having trouble getting the previous month's values returned using the following LOD expression. Any help is much appreciated!


      Formula for "Previous Month" Calculation Measure:

      If Max( {FIXED :MAX(DATE(STR(DATEPART('month',[Date])-1)+'/01/'+STR(DATEPART('year',[Date]))))} = [Date] )

      THEN [Percent PreArrived]