Beast Mode Case Statement Pivot Table issue
I have a Beast Mode calculation that has a case statement that looks to pull actual data from the past and projected data from the future. Everything works fine in the pivot table card with the exception of the total. It appears that the case statement is affecting the total instead of the pivot table just summing the individual values. Is this a bug or expected behavior? Any suggesting for solving or a work around would be much appreciated!
Below is the formula and the result.
WHEN `IMPORT_CLOSE_DATE`<= CURRENT_DATE() then sum(`Pacing_Revenue_Forecast GROSS`)
ELSE (sum(`CY On the Books`)/ sum(`LY On the Books`)* SUM(`LY Finish`-`LY On the Books`))+ (sum(`CY On the Books`))