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