About formatting in a NAV 2013 Report


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 :)