AnsweredAssumed Answered

How to email currency with thousand separator but not decimals

Question asked by monicapope on Oct 11, 2015
Latest reply on Oct 12, 2015 by mlauer

SharePoint List items

Field type: currency, no decimals.  Output ex.: $1,500



Email HTML table (daily cost report) with desirable output $1,550. This is because the numbers reported are in millions.



Inline function currency() displays cents/decimals. Output $1,550.00. 

Storing field as number type variable, output is missing the thousand separator (ex.: 1500).

Wasn't able to format the variables (number, text or currency types) to the desired format.

I tried using inline function with text variable (remove() and round()), but I must be doing something wrong,  it’s parsing the literal text.  I thought this would be something simple but I'm stuck.  Any help is much appreciated.  Thanks!