Hi,
I have measure field(Amount) and want the field to be "EMPTY SPACE" when NULL is given .I know you can simply create a calculated field saying
Ifnull(str([Amount]),'')
But I don't want it to be converted to string .Is there a way we can a Empty space or no data Instead of NULL for a measure value
Thanks,
Rahul
12 answers
Hi,
Follow the syntax which is in image below.
Null is replaced by two empty spaces.