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.

Thanks for your response on both questions! They're actually slightly different as I couldn't figure out the date trunc so I tried importing the data as quarters instead of months. (In reference to the other question with the string data conversion) This is more about why a date trunc is truncating to months instead of quarters, or returning null.