Online Documentation: Configuration Manual
Syntax for formulas used in the Calc NV type
If the following 'variables' are defined: (These 'variables' can be any information that
is recorded on the Part Record)
- A = 12
- B = 15
- C = 1.5
- D = 18.123
- E = Hello
- F = World
- G = 3/31/2002 12:00:00 AM
- H = 5/2/2002 12:00:00 AM
Note: Formulas are case insensitive
You can used these 'variables' in formulas, like is shown in the following examples:
- 1+2 -> 3
- [E] + ' ' + [F] + ' !' -> Hello World !
- IIF([A]>[D],[E],[F]) -> World
- Format('dd-MM-yy', Now()) -> 17-02-09
- Format('f',[E]) -> 18.123
- Format('f1',[E]) -> 18.1
- Format('f2',[E]) -> 18.12
- Format('f4',[E]) -> 18.1230
Functions
You can use the following function in the formulas:
- sin(), cos(), pi()
- sqrt()
- abs()
- iff()
- max(), min()
Useful Links
Click one of the following links to learn more: