How to show values like 50m ,40k on chart bars?

[#1]

How to show values like 50m ,40k on chart bars?

please find the attached doc

thanks.

apps

[giakoum]

put k for thousand, M for million etc and also check Values on data points in the expression tab.

[Sokkorn]

Hi,

Your expression should be like this

If(Sum(FieldValue)>=1000000,Num(Sum(FieldValue)/1000000,'#,##0M'),Num(Sum(FieldValue)/1000,'#,##0K'))

Regards,

Sokkorn

[#4]

Hi,Sokkorn

iam not getting symbols

please find the attacged iamge

[Sokkorn]

Hi,

Can you share your expression here? And make sure in use "Expression Default" in "Number" tab.

Regards,

Sokkorn

[#6]

If(Sum(Access)>=1000000,Num(Sum(Access)/1000000,'#,##0M'),Num(Sum(Access)/1000,'#,##0K'))

i set expression as default in number tab

[Sokkorn]

Can you share your app?

[Sokkorn]

See sample app in attached file.

[#9]

i am chart type style as ''stacked''

that why its not displaying

[Sokkorn]

Hi,

We should close this discussion.

Rgds,

Sokkorn