How to change the amount in ind format

Finance and Operations/AX Developer Forum
1

Hi,

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.

2

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?

3

Hi Martin,

Thanks for the reply.

It is SSRS report and AX 2012 r2 version.

4

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”)).

5

Thanks Martin,

It’s working. thank u very much

6

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.

7

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.