I'm trying to convert the null values of numeric field as '-'. My numeric field is formatted with currency '$'.
When I use the default setting to '-'. The null value appears as '$-'. However, I want it to appear as '-'.

The following code works for the string field. However, when I try this for the numeric field I get error message that a "number is required".

If IsNull({Command.NUMERIC_DATA_01}) OR {Command.NUMERIC_DATA_01} = ' ' Then '-' Else {Command.NUMERIC_DATA_01}

Please guide me as to how I can make this working on the numeric field. Thanks


Edited by mh9876 - 15 Feb 2018 at 5:42am