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!