% calculation for a table card
I need to calculate the percentage in a table card, the table like this:.
I want to calculate the % based on Sent. e.g delivered % =4800/5000, Total bounce % =120/5000.
I wrote this beast mode, but return nothing, can you please let me know what is not working.
WHEN `Category` IN ('Delivered','Total Bounce','Opens','Unsubscribes')
THEN (`total`) END)
WHEN `Category` IN ('Sent')
THEN (`total` )