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