Rounding / Formatting Dollar Amount In Straight Table

[pnn44794]

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.

[sergio0592 · Accepted solution]

It works with : money(round(sum([Total cost])/1000,0.1),'$# ##0,0 K')

[pnn44794]

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?

[MarcoWedel]

see also:

Re: Running Total In A Straight Table

hope this helps

regards

Marco

[pnn44794]

Thanks for your reply Marco.  I'm looking at the other question you responded to.