11 Replies Latest reply on Jun 15, 2016 7:43 AM by Mercedes Cobas

    Replace null with empty space in measure

    Rahul Sahil

      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