How to Format Column Totals in Grid

[kklosson]

How do I format a column total as currency?
Here's what does not work.

Screenshot_10.png (37.82 KiB) Viewed 32796 times

[customaware]

Try adding single quotes around the Number Format.....

<b>Total Income: <<SUM Income.Amount, '$#,##0'>></b>

[ACDC]

This will work for number formatting in the grid

<b>Total Income: <<SUM Income.Amount@#,##0.00>></b>

As to the $, you may have to use html,

[kklosson]

I'm afraid neither of the above is working.

[ACDC]

I'm afraid neither of the above is working.

Thats strange, this works for me: (on a Query Grid, not sure about a form Grid)
<div style="text-align: right;background" font-weight: 900; background-color: #d3d3d30a; ><<SUM GenLedger.Credit@#,##0.00>></div>

Did you remove the $ and the comma after the Amount and replace with an @

[kklosson]

I suspect either this item is not fully built out or there are limitations.

[rocketman]

The reason why it is not working is because in the bounded RED area you have two commas which signals to AwareIM that you have three variable,
Income.Amount then a variable with $# then another variable containing ##0

You could try changing the $#,##0 to be $#.##0 and see if either the attribute format or the locale format takes care of it. Other than that - I'm stumped. In the past, to get round this I've used Total Amount: £<<SUM Income.Amount,0.00>> which kinda worked until I got a European customer who needed commas instead of full stops as the decimal separator. Fortunately they were very understanding.

Maybe this is one for Vladimir