Format Number (in Thousand)

[xavieravinson]

Hello All,

I want to show a big Number in a KPI Chart or in Table chart. Want to format the number precision with thousands separator instead of using millions separator.  

For Eg: 100,789,567.00 want to display this in 10,07,89,567.00

Please help me to solve this. 

With Regards,

Xavier.

[Anil_Babu_Samineni]

Perhaps this?

=Num(FieldName, '#,##,##,##,##0.00')

[xavieravinson]

Hello,

Thanks for your reply. Tried this already its working in KPI's. IN Charts Axis is not coming properly while using this.

With Regards,

Xavier