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

    Replace NULL in numeric field

    julian.ramirez.0

      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.