1 of 1 people found this helpful
Use the sum in the below calcualtion
(SUM(IFNULL(([_YTD Actual]),0))-SUM(IFNULL(([_PY YTD Actual]),0)))
SUM(IFNULL(([_PY YTD Actual]),0))
This will give the required value if the _YTD Actual and _PY YTD Actual is showing as SUM aggregation in Measure values instead of AGG
If it didnt help kindly attach a workbook with some sample data
If it helps plz mark this answer as correct and helpful to close the thread
it worked. thanks!