Q2'18 MGT DA

ZN(IF str(DATEPART('year',[Fiscal Quarter]))= '2018' AND str(DATEPART('quarter',[Fiscal Quarter] )) =STR({MAX(DATEPART('quarter',[Fiscal Quarter] )})

THEN [Ship Final Act-Fcst]

END)

Q1'18 MGT DA

ZN(IF str(DATEPART('year',[Fiscal Quarter]))= '2018' AND str(DATEPART('quarter',[Fiscal Quarter] )) =STR({MAX(DATEPART('quarter',[Fiscal Quarter] )}-1)

THEN [Ship Final Act-Fcst]

END

Q1'18 MGT DA

ZN(IF str(DATEPART('year',[Fiscal Quarter]))= '2018' AND str(DATEPART('quarter',[Fiscal Quarter] )) =STR({MAX(DATEPART('quarter',[Fiscal Quarter] ))}-1)

THEN [Ship Final Act-Fcst]

END

Try now

I used FIXED, If you have some filters, add Them to CONTEXT to get same Results

Hi Helen,

Just responding from the other post, if you want to automate the calculations, using Deepak's response replace the '2018' with a parameter, and the Quarter selection with a current quarter parameter (1-4).

You can work out the previous quarter for your calculated fields using the same parameter that you use for current quarter with another calculated field (pseudocode below) or just add another parameter to let users set the previous quarter as well.

If [current quarter] = "1" then [last quarter] = "4" AND [Year] = [Year Parameter]-1

elseif [current quarter] = "2" then [last quarter] = "1"

elseif [current quarter] = "3" then [last quarter] = "2"

elseif [current quarter] = "4" then [last quarter] = "3"

END

HTH

Peter