|
Hi everyone, I am working on a report based on Sales Invoices (table 113) in NAV 2013 R2. I looked in the table, the amounts in the differentlines do not have the same format : sometimes they have 2 decimal places and sometimes they have 3 decimal places (it depends on the currency, I think). I tried TextBox Properties ->Number and I chose default in the category, but it didn’t much my need (when the value is integer for example 10, the reports displays 10 and not 10.00 as I need, and when it is a decimal like 10.6 , the report displays 10.6 and not 10.60 as I need). What shall I do to get the format as it is in the table line? and how can I add a thousand separator? Thanks in advance  |
|---|
The thousand separator I need is a space…
I tried to use the FORMAT function, I found the following code but didn’t know how to use it:
FORMAT(YourDec,0,'<Sign><Integer Thousand><1000Character,,>')
Can anyone give me a concrete example (with values) so that I can apply it to my code?
Thanks in advance