usd $ dollar sign and % after each item in reports

swiftinitpvtltd

We have
PURCHASE PRICE 148.60 1408.73 56349.12
SELLING PRICE 180.00 1854.00 74160.00

need it like

PURCHASE PRICE 148.60% $1408.73 $56349.12
SELLING PRICE 180.00% $1854.00 $74160.00

This is in aware reports and it uses find query to get multiple items so I can not add static %

All are number values.
How to get % and $ signs in aware reports in table grid items with find query.

Checking-

swiftinitpvtltd

Rule on Project BO
Project.ContractTotalIncVat_AS_STRING=SystemSettings.CurrencySymbol+AS_STRING(Project.ContractTotalIncVat,'#,##0.00') from Gabbitas worked really nice for me. Thank you.

rocketman

Is there a reason why you can’t format these attributes as currency?

Formatting as currency means when displayed the symbol will be picked up from the locale. If you sell your app in multiple countries, they willlveach see their own currency symbol.

For the percentage attribute, format with a custom mask - something like #.##%