Hello,
I am trying to figure out what is wrong with my 3 beastmodes. One for this year's email sends, one for last year's email sends, and one for this year vs last year's difference.
Currently, the chart looks like this and the beast mode doesn't seem to be calculating correctly in each row plus the subtotal.
This Year Email Sends beast mode is:
CASE WHEN FY Order
= 0 THEN COUNT(cm_pla
) ELSE 0 END
LastYear Email Sends beast mode is:
CASE WHEN FY Order
= 1 THEN COUNT(cm_pla
) ELSE 0 END
This Year vs Last Year difference beast mode is:
((CASE WHEN FY Order
= 0 THEN COUNT(cm_pla
) ELSE 0 END)- (CASE WHEN FY Order
= 1 THEN COUNT(cm_pla
) ELSE 0 END))
If someone can help me look into this, I would appreciate it.
Thank you in advance!