Convert A Number To Blank

[Former Member]

Is it possible to convert a number to blanks (for exporting purposes) ? I need for the column to have blanks instead of zeros.

[Former Member · Accepted solution]

Hello,

Right click your field-->Select 'Format Field'->Common tab->Check suppress-->click on formula box infront of suppress.

Now in that formula editor, right the condition which will be always true for the number like :

{Customer.Customer ID}>=0

This should supress all the numbers to blank.

Hope this helps .

Regards,

Chinmay Athavale

[Former Member · Accepted solution]

Chinmay,

Thanks ! ! ! That worked . . .

[Former Member]

Substitue your field names

if {Orders.Order ID} = 0 then totext (" ") else totext ({Orders.Order ID})

This should work, if you don't care about changing the number to text.

[Former Member]

V361,

Thanks Chinmay solution worked . . . Thanks anyway ! ! !