Hi All
I'm trying to calculate the percentage of a column (that is aggregated) using this beastmode
(SUM(CASE WHEN `Cluster` = 'Greater North' THEN `Uno`
Else 0
END)) /Sum(`Uno`) *100
However, in the table it shows "100" although in the Total it does have the right percentage!! (sse pic)
What I am doing wrong?
Thanks