Amount in proper format

[vinod2086]

i want to dislay total amount in proper format in table pls help

143294587.76802

[sunny_talwar]

Have you tried changing the settings on the number's tab of chart properties? What is the proper format you are looking to get?

[Anil_Babu_Samineni]

I am not sure whether I understand your issue. Would you describe more

[vinod2086]

i had tried but option is not enabling

u mean number tab only ryt

[vinod2086]

it is displaying larger number ryt so want to display with out decimals

[sunny_talwar]

Yes the numbers tab. What happens when you change the format on the numbers tab?

[sunny_talwar]

Selecting 'Integer' doesn't help?

[krishnacbe]

Try to format in expression

num(Expression,'#,##0.00')

[vinod2086]

same thing i had tried but option is disabled

[neelamsaroha157]

Sunny is right 1st try on the Number format tab and if it doesn't work (although it should ) then try the Num() function.

Num( your_expression , '#####.0000')