Format a large number on report totals line. Is it possible?

[sgtrwe]

Hello, I'm trying to format a large number (17GB) with commas on the report total line.
This doesn't work Mediasize: {to_char(SUM.Mediasize.0, 'FM99,999,999,999')}
if I use this Mediasize: {SUM.Mediasize.0}
I get this number "Mediasize: 17777085462"
If I format Mediasize in the select statement it formats correctly, but the SUM doesn't work on the formated field.
Is there a way to format the number on the total line ?

Thanks
Bob

[bobintetley]

There isn't an easy way. I guess we should have had an option, or made our {SUM} token do the number grouping by default, although I can't remember if we keep info on number group sizes in the locale. I'll put a ticket on our dev list about this.

Probably the only way to do it right now is to use the {SQL.[query]} token, which depending on the complexity of your query may not be possible. That token allows you to write a complete query (including to_char) to calculate a value to output.

[sgtrwe]

Thanks for the fast reply, apparently if the field is named "SUM.amt" it formats as money with the commas, but you cant do "sum.amt.0" to remove the cents.
I was able to use the SQL.Select and get the results, although this early it took me too many tries to get it right. lol
heres the result
Total Size: {SQL.SELECT to_char(sum(MediaSize), 'FM999,999,999,999') FROM media}