14 Replies Latest reply on Jan 28, 2019 1:55 PM by Jeremy Dempsey

    Ignore quick filter in MTD calculated field

    Jeremy Dempsey

      How can I get the amount Month to Date no matter what date is selected in the quick filter?  I believe I have to use a Fixed LOD expression somehow in the calculation, but not sure how.

       

      if datepart('month',[POSTED_TS]) = datepart('month',TODAY())

      AND datepart('year',[POSTED_TS]) = DATEPART('year',Today()) then [Amount] END