The Round Up From defines the point at which Prices are rounded up.
The Price is treated as a series of digits:
- Penny digit: $0.01
- Ten cent digit: $0.10
- Dollar digit: $1.00, etc.
For each digit to be rounded, enter the number from which it should be rounded up.
For each digit that that should not be compared, enter X.
For example:
X.50 - Round up all prices that end with 50 cents or more. Round down prices that end with 49 cents or less.
The most significant digit of a Price is normally not changed unless necessary for rounding down.
For example, using a Price Pattern of X.95 and Round Up From of X.30:
$0.29 rounds down to $0.25.
$0.89 rounds down to $0.85.
$1.00 rounds down to $0.95
$7.60 rounds up to 7.95
Use the "Q" character in the Price Pattern field on formulas to round to the nearest Quarter. If "Q" is used then that portion of the Round Up From mask is used to offset from the quarter to which the price would round. So if set to round up at 10 cents, it would actually round up from .10 (based on .00), .35 (based on .25), .60, (based on .50) and .85 (based on .75). For example, with a Price Pattern of X.QX and a Round Up From of X.10, the prices would round as follows:
$1.00=$1.00
$1.09=$1.09
$1.10=$1.25
$1.34=$1.25
$1.35=$1.50
$1.84=$1.75
$1.85=$2.00.
To always round up, use .01 in the Round Up From field (then $1.26=$1.50).
Use the Test button to test the price rounding settings. Enter a price and click on Test.
More Price Pattern / Round Up Examples
See:
Price Tables - General Information
Configuration Manager Contents