4 Replies Latest reply on Feb 1, 2019 4:50 AM by Shaquelle Jacobs

    12 Months Previous

    Shaquelle Jacobs

      Why the 12Months previous calculation can't be control by the date filter, but the parameter? any solution to this problem ?

      IFNULL(INT(sum(if [Date Reported] >= DATEADD('month',-24,[Selected Date ])+1 and [Date Reported] <= DATEADD('month',-12,[Selected Date ]) then [ 12 Months Previous Mileage ]

      end)

      /

      sum( [ 12 Months Previous RC])),0)