I have an analysis that includes several detail lines, along with a subtotal and a grand total.

The amount fields in the detail are properly formatted to include a currency symbol ($) and commas.  The subtotal also has the correct format.

However, the grand total does not have the same format.  There is no currency symbol ($) and no commas.

We have noticed, however, that if we wrap a function around this amount (for example, ABS(trans_amount), then the formatting is correct on the grand total.

Any idea what's causing this?  Or what we can do to fix this?

Thanks!

Dennis