Dataport EXPORT to show Zeros as blank

paddypower

Hi Everyone

Version NAV 2009 SP1 SQL

Hi Guys,

I am trying to run a dataport picking up a decimal field to export. The issue is I want the exported field to be BLANK if the value is ZERO.

Please help.


Regards,

PP

Savatage

Convert the decimal to text.
Variable - ExportedField - Type Text

If "My Decimal Field" = 0
then ExportedField := ''
else ExportedField := format("My Decimal Field");

And use Exportedfield as your dataport field

Save->Compile->Enjoy!