Dividing with Multiple Beast Mode Functions
I have 2 formulas I am trying to divide into one another CASE WHEN `Action` = 'Lead' THEN SUM(`Unique Events`) END and CASE WHEN `Action` = 'Completion' THEN SUM(`Unique Events`) END Individually they work fine and result in 100000 and 50000 respectively. I need to divide Completions into Leads to determine my dropoff rate…
