I am trying to calculate the difference between periods for a specific metric and am running into some trouble. (As you can see from the screenshot below, the Beast Mode calculation I am using doesn't seem to be working.)
To generate the column totals, I am using this beast mode successfully for each desired date comparison: (example for current below)
CASE when `Period Type`='Current' then `Shipped CoGS`end
However, when trying to calculate the difference between these periods, the formula is validated but doesn't work:
((CASE when `Period Type`='Current' then `Shipped CoGS`end) - (CASE when `Period Type`= 'Last Month' then `Shipped CoGS` end)) / (CASE when `Period Type`='Last Month' then `Shipped CoGS`end)
What am I missing?