Hi all,
I have my field Amount but it has some null fields. I tried these calculated fields to replace the Null value by blanks but none makes what I want.
- IFNULL(INT([Amount]),INT(' '))
- IFNULL(STR([Amount]),' ')
- IF ISNULL(SUM([Amount]))then INT(' ') else SUM([Amount])END
I want to someway replace null values by blank and leave the result as number to change the format to currency.
Any idea about this?
Regards,
J.
답변 4개
Hi Julian
As long as the "Amount" fields are categorized as "measure", then tableau will not display NULL values.
