I am having trouble with the below calculated field. Since the Avg SU per Writer - Depth is an aggregated calculation, I believe I am getting this error. Any help is appreciated to fix this error.
Thank you
zn(IF [Week Ending Date]<={FIXED : MAX([Week Ending Date])}
AND [Week Ending Date]>DATEADD('week',-4,{FIXED : MAX([Week Ending Date])})
THEN [Avg SU per Writer - Depth] end)
While the calculated field is now valid with the modified code (including the ATTR and removing the FIXED), the result when I move the field to the Measure values is 0 for all rows (see below attachment).
However, the result in the view shows values (all weeks not just the 4 weeks that I want) if I just move the Avg SU per Writer - Depth to the measure values. I am unable to load the packaged workbook due to restrictions unfortunately.
