How to change the amount in ind format


this is my total amount 600000

in my report it is displaying 600,000 format

how to display it in 6,00,000 format.

Please help me.

Thanks in advance.

Is it a MorphX report or a SSRS report? What’s your version of AX? Should it be displayed in this format regardless of the format configured in Windows?

Hi Martin,

Thanks for the reply.

It is SSRS report and AX 2012 r2 version.

You can, for example, use the Format function in the value expression and pass a custom format into it (e.g. =Format(Fields!Amount.Value, “#,##,##0”)).

Thanks Martin,

It’s working. thank u very much

Hi Martin,

It is working only for six digit no

for 8 digit it is coming 100,00,000 &

for 5 digit it is coming ,10,000 &

for 4 digit it is coming ,1,000 &

for 3 digit it is coming ,100

How to rectify this please help me,

Thanks in Advance.

I showed you how to use number formats - now you have to define the right format according your requirements. The documentation is here: Custom Numeric Format Strings.