After set format string to 2 decimals at purchase requisition discount column still not work

Created by Ariel Hoong, Modified on Tue, 5 Sep, 2023 at 8:47 AM by Ariel Hoong

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article