Suppress 'X' in display

[Former Member]

Hi All,

I have a coulmn in the report with formula( b-c)/b, in query its diplaying 'X' for values that are divided by 0......so is it possible to replace this X with blank......

please suggest

Regards,

Raj

[Former Member · Accepted solution]

It is not possible to replace X values in query. You can only supress 0 in query. But you can always create a formula with the value multiplied by 0 to remove X.

[Former Member · Accepted solution]

You can use NODIV((b-c)/b) which will replace X with 0. then you can replace 0 with blank, but that will replace all ZEROS with blank in the query.

- Danny

[Former Member]

Hi,

Its not possible in the settings at query level....

Edited by: Puneesh Gupta on Jun 17, 2009 10:05 AM

Edited by: Puneesh Gupta on Jun 17, 2009 10:05 AM