4 Replies Latest reply on Apr 27, 2018 6:14 AM by Jim Dehner

    Quarter Datetrunc Issue

    Heather Smith

      I have used a datetrunc calculation to truncate my data to the quarter level. However, when I try to display sum of sales, it only shows the sales for the last month of the quarter, or it displays null. 


      To display the most recent quarter, I'm using this calculated field as a true/false filter: DATETRUNC('quarter',[FOR YR MO])=[Report Quarter]


      Where [Report Quarter] is a parameter with step size= 1 quarter and min date = 9/1/16 with allowable values = range of values.


      Any idea why my date trunc is excluding quarter values or reverting to months?