Dataport Question

Business Central/NAV Developers Forum
1

I have a variable unitprice in dataport that needed to be exported in this format ###.##

that i need three decimals …

I wrote in side dataport ONBEFOREEXPORT RECORD( )

UnitPrice := ROUND(SalesPrice.“Unit Price”, 0.001 , ‘=’);

if it’s 16.576 then itis exported 16.576 …

if it’s 16 then it’s exported 16 while i need to be exported 16.000 …Do you know anything to make this field alway exported in this format

Thank you foir any one can help

2

You could use format function

FORMAT(value, 0, ‘<Precision,3:3>’)

3

Thank you Nunu … it works perfectly