Skip to main content
Solved

Report Designer - Format qty & Price to 2 decimal places only

  • 15 July 2022
  • 1 reply
  • 2665 views

On the default Sales Order print out the Quantity, Price and Discount Percent field prints out to 4 or more decimal places.  Example

 

How do i modify the format in the Report Designer to only Print 2 decimal places. So the qty reads  1.00, price reads as 17,198.00 and disc pct reads 3.43%   I am assuming i change this in the Appearance row for each field.  I can not get the correct Syntax.  Example below is what is in there by default.

 

Best answer by rkerr58

You are in the correct area.  This chart should help with the syntax:

 

 

On the price format, you should be able to change the appearance format to the Extended Price and it will copy that format instead. 

View original
Did this topic help you find an answer to your question?

1 reply

rkerr58
Jr Varsity I
  • Jr Varsity I
  • 8 replies
  • Answer
  • July 15, 2022

You are in the correct area.  This chart should help with the syntax:

 

 

On the price format, you should be able to change the appearance format to the Extended Price and it will copy that format instead. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings