i NEED HELP WITH "FORMAT"

Business Central/NAV Developers Forum
1

In a source expression I am trying to use ‘$’+ format(number)+’ + Sales Tax’ All works fine if the number is ####.## but if the number only has one # to the right of the decimal like 345.30 I get $ 345.3 + Sales Tax and I need $ 345.30 + Sales Tax Any ideas how to easily set the format to get the desired results?

2

Maybe try converting the number to a string?!

3

I had the same problem. I think this is what you’re looking for: FORMAT( “Amount Including Tax”, 0, ‘<Precision,2:2><Standard Format,3>’ ) --Michael

4

Thanks MIchael-- That did the trick!