$ in summary of a query column

tford

I have this in the Summary section of a query column:

<DIV align="right"><b><<SUM School.Sales_YTD@$#,###>></b></DIV>

The total correctly shows, but the $ of the format DOES NOT.

Any clues?

customaware

Try...

<div style="text-align: right;"><b>$<<SUM SUM School.Sales_YTD@#,###>></b></div>