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"><<LIST_TABLE_START('FIND OurReport WHERE(OurReport.LotID=LoggedInSystemUser.CurrentLotID AND OurReport.ob_ReportUser=LoggedInSystemUser)')>><<OurReport.ROIType>></p></td>
<td class="tableitem"><p class="itemtext"><<OurReport.CWT>></p></td>
<td class="tableitem"><p class="itemtext"><<OurReport.Head>></p></td>
<td class="tableitem"><p class="itemtext"><<OurReport.ROIValue>><<LIST_TABLE_END()>></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
usd $ dollar sign and % after each item in reports
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: usd $ dollar sign and % after each item in reports
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
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
Re: usd $ dollar sign and % after each item in reports
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 #.##%
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
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5