1 of 1 people found this helpful
Append the calculation with
ZN like below
ZN because you are using IF Condition false condition giving NULL,
So NULL + anything will give NULL
Hope this helps kindly mark this answer as complete or helpful so that it will help others
Thank you so much for your answer. This definitely did the trick for that part!
However, after that when I try to do BME Total/Totals Pivot Table it does the wrong calculation.
For example, in the case of the Borough of Bromley in 2011, the total population (Total Pivot Table) was 311.107 and the BME Population is 65.835, which should give 0.21. However, when I use BME Total/Totals Pivot Table it gives 288 as answer.
What am I doing wrong?
Than you so much again and sorry if my questions are too silly, this is my first Viz.
Thank you Meenu! this was very helpful!
Thank you so much! This worked perfectly.