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 respuestas
Hi Julian
As long as the "Amount" fields are categorized as "measure", then tableau will not display NULL values.
