Calculations in numerical fields
Instead of a value, you can enter a calculation in a field. Profit saves the calculated value. This allows you to perform simple calculations without the need for a separate spreadsheet.
You can do this in the Profit numeric fields, both in properties windows and in entry layouts.
The maximum length of a calculation is 30 positions. You can combine multiple operators. Calculations are performed in this sequence:
- Calculations between brackets are performed first.
- Exponents and square roots
- Multiplication and division
- Addition and subtraction
To perform a calculation in a numerical field:
- Go to: a numeric field, such as in an entry layout or a wizard.
- Enter a simple calculation using an operator and numbers.
- Press = to retrieve the answer to the calculation.
Profit will show the answer to the calculation in the field.
- If you want to change the calculation, press Backspace. The answer disappears and the formula you entered is displayed again.
- Press: Enter.
Profit displays the answer. Because you have exited the calculation by pressing Enter, you can't retrieve it anymore.
Below are the operators you can use.
Operator |
Explanation |
Example |
|---|---|---|
+ |
Add |
2+4 |
- |
Subtract |
3-6 |
* |
Multiply |
6.5*54.24 |
/ |
Divide |
4/7 |
^ |
Raise to the power of |
18^3 |
( ) |
Calculate first |
(8+4)/3 Profit first calculates the section between parentheses, in this case 8+4=12. Followed by the rest of the calculation: 12/3 = 4. |
|
Directly to
|