4 Replies Latest reply on Aug 28, 2018 7:07 PM by julian.ramirez.0

    Replace NULL in numeric field


      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?