This formula type is used exclusively for financial calculations. The data type is based on
currency, but numerical data can be used in the calculation for multiplication, etc. It’s possible
to use text methods that provide a numeric output, but not recommended.
Currency formulas use the same operators and methods as the Numeric formulas, so they
won’t be listed again here. Any of the methods and operators in the: Additive, Multiplicative, Compare, Relational, Rounding and Truncating, and Sign categories can be used in currency formulas. Any of the formulas in the Calculation, Constant, Trigonometric categories should not be used for currency calculations.
An example formula is:
Min([price1]+[price1]*[tax]+[shipping1]+[fee1],[price2]+[price2]*[tax]+[shipping2]+[fee2])
This formula determines the lower price for two different purchase options.
When using two or more operator types in one formula, the order of precedence for the calculation is as follows:
- Unary (such as –[num1])
- Multiplicative
- Additive
- Relational
If parentheses are used, like those in methods like Max(), Min(), Truncate(), etc., the expressions within the parentheses are evaluated first.