usd $ dollar sign and % after each item in reports

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

usd $ dollar sign and % after each item in reports

Post by 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.

<tr class="service">
<td class="tableitem"><p class="itemtext">&lt;&lt;LIST_TABLE_START('FIND OurReport WHERE(OurReport.LotID=LoggedInSystemUser.CurrentLotID AND OurReport.ob_ReportUser=LoggedInSystemUser)')&gt;&gt;&lt;&lt;OurReport.ROIType&gt;&gt;</p></td>
<td class="tableitem"><p class="itemtext">&lt;&lt;OurReport.CWT&gt;&gt;</p></td>
<td class="tableitem"><p class="itemtext">&lt;&lt;OurReport.Head&gt;&gt;</p></td>
<td class="tableitem"><p class="itemtext">&lt;&lt;OurReport.ROIValue&gt;&gt;&lt;&lt;LIST_TABLE_END()&gt;&gt;</p></td>
</tr>

Checking-
viewtopic.php?t=9891
viewtopic.php?p=96

in previous project we used some kendo script to get this $% after render but it does not work well in reports
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: usd $ dollar sign and % after each item in reports

Post by 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.

viewtopic.php?t=9891
rocketman
Posts: 1239
Joined: Fri Jan 02, 2009 11:22 pm
Location: Preston UK
Contact:

Re: usd $ dollar sign and % after each item in reports

Post by 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 #.##%
Rocketman

V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
Post Reply