Numerical fields are used for entering numerical values into the application. When entering values in numerical fields it's possible to enter formulas, e.g. make simple calculations.
N/A
N/A
N/A
N/A
The numerical fields can be edited by clicking inside the fields, or by moving the input focus to it by pressing the Tab key to get to it. Some fields are by design not updateable.
All fields and columns, having the numerical format mask (numerical fields), can be edited using mathematical formulas. There are two possible ways to accomplish a mathematical operation:
Example:
will result in
Example:
will result in
Note: In order to have decimals in the result the formula must be entered with decimals. E.g. "1/3" will result in 0. Enter "1/3,0" to display the decimals in the result, e.g. 0,333333333333333333333.
Possible operators: | |
+ | Addition |
- | Subtraction |
* | Multiplication |
/ | Division |
( ) | Parenthesis for grouping expressions |