How to Format Column Totals in Grid

kklosson

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

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