Try this to replace null to 0.
Above will work when null in place.
Want to replace only city=bangalore else replace all null to 0.
Reads: If City is Bangalore, then Zero if value is NULL, else value.
Thanks for your quick reply. If we use that calculation it will make zero for measure wherever it is having null value.
But I want like below
If [city]='Banaglore and [measrefield]=null then I want to replace for that city measure value as 0.
1 of 1 people found this helpful
Ah! Wrap city with ATTR
or disagregated form by removing SUM
Thanks Prayson. It is working now.
You are welcome