Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I think I've been looking at this problem too long and trying too many different ways to get what I need done. I'm missing something simple.
I have values in a straight table, fieldname Total Cost, like the following:
Total Cost
2164
-97295
10094
127433
etc
I want the values to be formatted as follows:
Total Cost
$2.2 K
-$97.3 K
$10.1 K
$127.4 K
Any suggestions? As always, I appreciate any and all responses. Thanks in advance.
It works with : money(round(sum([Total cost])/1000,0.1),'$# ##0,0 K')
It works with : money(round(sum([Total cost])/1000,0.1),'$# ##0,0 K')
Thanks for the reply Jean-Baptiste. Total Cost is a field that is not calculated. I pull it in via my load script from a database. Would this work in my load script or do I need to do this via an expression within the dashboard?
Thanks for your reply Marco. I'm looking at the other question you responded to.