The In-Line Calculator is available in nearly all numeric fields.
It can Add, Subtract, Multiply, Divide, Increase by percentage, Decrease by percentage, and Calculate a value based on a margin amount.
To use the In-Line Calculator:
- Select the field in which to perform the calculation.
- Enter the operator(s).
- Enter the amount.
- Press [Enter].
The result of the calculation are displayed in the field.
In-Line Calculator Operators
* - Multiply
Multiplies the number in the field by the amount entered. For example: number in field = 12, *5 is entered, Press [Enter], Result = 60
/ - Divide
Divides the number in the field by the amount entered. For example: number in field = 64, /4 is entered, Press [Enter], Result = 16
+ - Add
Adds the amount entered to the number in the field. For example: number in field = 19, +8 is entered, Press [Enter], Result = 27
+- - Subtract
Subtracts the amount entered from the number in the field. For example: number in field = 112, +-15 is entered, Press [Enter], Result = 97
Note: The +- operator combination must be used because the "-" sign by itself represents a negative value.
p - Percentage
Add a percentage to or subtract a percentage from the number in the field. The "p" follows the umber entered. For example: number in field = 19, +30p is entered, Press [Enter], Result = 32.5
M - Margin
Change the current value to provide the margin percentage entered. New value=Current value/(1-%). For example: number in field = 1.5, M40 is entered (for a 40% margin), Press [Enter], Result = 2.50.
Note: The Database Manager Search and Replace function has its own in-line calculator.