Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have currency as 56,877,786.96
i want to show this as $56,877K in the dashboard.
How can I achieve this in straight table.
Thank you Much for your time.
Maybe like
='$' & round(CurrencyField/1000) & 'K'
or just
=round(CurrencyField/1000)
and use this
$#,##0K;-$#,##0K
as format pattern for money on number tab for that column.
You can set the format of the expression on the Number tab. Choose Money and change the Format Pattern to your needs. You can also use the num function around your expression: num(Sum(Value)/1000,'$#,##0K')
Thank you Much for your reply, but there is one issue.
$56,789 will be $56K but the expression $#,##0K;-$#,##0K
Is showing it as $56,789K
Can you Please see.
Thank you Much for your reply, but there is one issue.
$56,789 will be $56K but the expression $#,##0K;-$#,##0K
Is showing it as $56,789K
Can you Please see.
You'll need to state the decimal point and thousand separator then in the format function:
=num(56789 / 1000,'$#,##0K','.',',')