Remove COMMA(')

ashrafcbz

Hi,

How can i remove COMMA(,) from a decimal field in reports.
or how can i convert amount field into indian amount formate.

Thanks In advance

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

Check the format-property on the field in the report.
With that you can select how many decimals you want and how the format must be.

Curiosity : what is the Indian format?

ashrafcbz

hi,
thanks for reply.

eg::indian 1,00,000.00
in navision it shows 100,000.00

ashrafcbz

kriki wrote:

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]

Check the format-property on the field in the report.
With that you can select how many decimals you want and how the format must be.

Curiosity : what is the Indian format?

for removing COMMA how can i set the formate property.

matttrax

Seems like a strange format. Still, look into the FORMAT function and property. If you cannot find the options to create the format you want you will have to build your own function. I can't imagine the Indian number formatting wouldn't be there, though.

hawkeye

I would use the DELCHR function. Look in help how to use it. It can delete all your commas

Hanen

NewAmount:= DELCHR(Amount,'=',',');

MGM08

viewtopic.php?f=23&t=47012

Hope this helps

vaprog

NAV standard format uses Windows regional settings. You might want to take a look on those.

st0328

Hope this helps

http://www.mibuso.com/forum/viewtopic.php?f=1&t=46854