Hi,
I was wondering if it was possible to format a value which is presented in a column on a query.
What i mean by that is i have a query that lists "Settlements"
They query is grouped by Settlement Months, I have a "display summary for each group" that shows a "SUM" in the calculation field and {Value} in the presentation field. Please see screenshot below -
It shows the value correctly but the value is not formatted like $###,###,###.00
Is there a way to format it like this ? ( $###,###,###.00)
