FORMAT property

ta5

Hi Experts

Nav Help https://docs.microsoft.com/en-us/dynamics-nav/format-property mentions the <Standard Format> property with the example
"<Precision,2:3><Standard Format,0> will use Standard Format 0 and will format the data with a minimum of 2 and a maximum of 3 decimal places"

I have tested this as following
FORMAT(TheNumber,0,<Precision,2:3><Standard Format,0>)

It works fine, but I don't see the meaning of the Zero in the term <Standard Format,0>. In my opinion, it conflicts with the Zero in the term FORMAT(TheNumber,0,....

Any ideas? Thanks for bringing some light to this topic. I've read the help, but unfortunately did not grasp it

Thomas

Kishorm

<Standard Format,0> is saying to use Standard Format 0. Each type has several Standard Formats - refer to the link you added at the start of your post to see what these are.

The 0 after TheNumber refers to the length (padding) - setting a 0 means use the full length.

Kishorm

<Standard Format,0> is saying to use Standard Format 0. Each type has several Standard Formats - refer to the link you added at the start of your post to see what these are.

The 0 after TheNumber refers to the length (padding) - setting a 0 means use the full length.

ta5

Hi Kishorm
Thx a lot. Makes sense now to me.
Regards and thanks again.
Thomas