Beast Mode % of the total in Chart
I want to create a calculated value that show the % of the total. I have done this:
SUM(Case WHEN `Country` LIKE '%In' then `Value` ELSE 0 END)
SUM(Case WHEN `Country` = 'TotalIns' then `Value` ELSE 0 END)
But it displays anything although the formula is correct. I tried using only the first part of the formula and it works, I don't understand what's wrong.