Coding Help Please

Dynamics 365 Business Central/NAV Developers Forum
#1

Hi Forum, I am amending an existing report that outputs a .csv file but having a problem when adding the “Unit Price” to the file. Basically when it outputs this value, if the price is 1000.00 it is output as 1,000.00. My code is

OutputLine := OutputLine + Text10002 + FORMAT(“Unit Price”); …Text10002 contains a comma (,)

I need to code it so that a value of 1000 or above does not contain the comma as per 1,000.00 but is 1000.00.

Hope that makes sense.

Can anyone help please. Paul

#2

Try FORMAT(“Unit Price”, 0, ‘<Precision, 2>’)

#3

Hi anfinnur,

that was the answer I needed, thank you very much. Paul