Problem with Number Format in Query Group Summary

customaware

I have an number attribute for which the format is.....

$#,##0.00;($#,##0.00)

This works fine when displayed normally.

However, in a Query whereby I turn grouping on and select Display Summary on this attribute, the Presentation shows the $, the thousands separator and the decimal point but it does not limit the number of decimal places to 2.

Is there any way to combine the Presentation {Value} with $#,##0.00;($#,##0.00) so as to display the Summary total correctly?

aware_support

Try using the format explicitly in the tag expression in the summary, for example:

Summary is <<Object.Value,$#,##0.00;($#,##0.00)>>