I want separator after three decimal in my report,
for e.g my amount is 4,00,000. (4 lakhs ).
i want 400,000 (400 hundred thousand )
and same in amount in words.
What version of NAV/BC are you running?
if you are running RDLC, then this is a setting on your field in the report.
i'm using nav 2013 r2 report builder 3.0
Right click your field, and go to textbox property and change the number format
it is only reflecting the symbol
you need to clarify what you mean.
What do you exactly need?
You might need to look at Check report to get amount in words
yes i have checked it but the issue is only with the separator i want it after three decimals as shown in above example
In my amount i want the separator(,) after three decimal like 400,000 by default it is showing 4,00,000
in the screen shot by Lars select number and not currency and try
are you showing just number or is it currency amount?