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