Scenario:
After set format string to 2 decimals at purchase requisition discount column still not work
Solution:
How to access Report Designer:
https://support.qne.com.my/support/solutions/articles/81000390974-how-to-access-report-designer
1) Go to report designer > at left hand side (Field List) search for Purchase Requisition Details Collection > right click > Add Calculated Field
2) After click will show new calculatedField1 > right click on it > Edit Expression Editor > Copy and Paste below script in the box > click OK
Iif(Contains([Disc],'%' ),ToDecimal(Replace([Disc], '%', '')) ,[Disc] )
3) Click and hold the calculatedField1 to drag it out and place to correct place
4) Click on the small arrow > Format String change to {0:N2} > Formatting Rules
5) Edit Rule Sheet…. > Add a formatting rule > Copy below script and paste at Condition > Formatting visible select Yes > Close
Contains([Disc], '%')
6) Click save and go to Purchase Requisition to preview disc column, it’s show 2 decimals
Additional request - Can show % next to the amount?
Yes.
1) Go back to Report Designer > Click on DISC > right click > insert > Column to Right > double click and delete the column name and adjust the column
2) Do same at Detail part to add column > double click and rename as % > adjust the column to make it in line
3) Save and check will show discount amount in 2 decimals and %
** Learn more about Azure Cloud
** Learn more about QNE Hybrid Cloud Software
Refer attachment for details
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article