Hello All,
I am having some issues with my BeastMode.
In plain language as I can muster here is what I am trying to accomplish. I am trying to have a logical test run two different calculation methods in the same beast mode.
Logically I want it to do the following
IF ID = 1
THEN ( ###ID ONE CODE###)
ELSE( ###ID TWO CODE####)
I just can't quite get the syntax right. Each Piece runs individually, but not together.
Here is the beast mode
(CASE WHEN `Dispenser_Number`= 'xxxx'
(COUNT(DISTINCT(CASE
WHEN `NetRevenue` > '0' AND `Purchase Category` = 'OBJECT'
THEN `Contact_ID`))))
ELSE(
(COUNT(DISTINCT(CASE
WHEN `Procedure_1` = 'METRIC' AND `Outcome_Desc` = 'Aid Sale' THEN `Contact_ID`
WHEN `Procedure_2` = 'METRIC' AND `Outcome_Desc` = 'Aid Sale' THEN `Contact_ID`
WHEN `Procedure_3` = 'METRIC' AND `Outcome_Desc` = 'Aid Sale' THEN `Contact_ID`
WHEN `Procedure_1` = 'Previous TNS' AND `Outcome_Desc` = 'Aid Sale' THEN `Contact_ID`
WHEN `Procedure_2` = 'Previous TNS' AND `Outcome_Desc` = 'Aid Sale' THEN `Contact_ID`
WHEN `Procedure_3` = 'Previous TNS' AND `Outcome_Desc` = 'Aid Sale' THEN `Contact_ID`
))))
END)
--edited for personal and identifying info