Finance Rules

CONTINUING DEVELOPMENT

The definition of available rules, operators, parameters and functions is part of an ongoing development process. Future delivery sets may offer a broader range of rules, and/or a broader range of rule options for currently available rules.

Syntax of HECS Formula Rule

Operators	Usage
( )	Definition: Parenthesis Example. (6-4)/3 Returns 2/3 or 0.666666…
ROUND(<value>,decimal places)	Definition: Round a number to so many decimal places Example. ROUND((6-4)/3,2) Returns 0.67
TRUNC(<value>,decimal places)	Definition: Truncates a number to so many decimal places Example. TRUNC((6-4)/3,2) Returns 0.66
,	Definition: comma, used to separate operand from parameter in rounding and truncation functions above. Example. See above
+	Definition: Plus Example. 10 + 11 Returns 21
-	Definition: Minus Example. 5-2 Returns 3
/	Definition: Division Example. 10/2 Returns 5
*	Definition: Multiply Example. 2*8 Returns 16

Parameter/Function	Description	Current Values
CHARGE_ELEMENTS	The derived value of the charge method
CHARGE_RATE	The derived value of the fee assessment rate

Variables	Description
Number	0-9

Syntax of Standard Fee Assessment Formula Rule

Operators	Usage
( )	Definition: Parenthesis Example. (6-4)/3 Returns 2/3 or 0.666666…
ROUND(<value>,decimal places)	Definition: Round a number to so many decimal places Example. ROUND((6-4)/3,2) Returns 0.67
TRUNC(<value>,decimal places)	Definition: Truncates a number to so many decimal places Example. TRUNC((6-4)/3,2) Returns 0.66
,	Definition: comma, used to separate operand from parameter in rounding and truncation functions above. Example. See above
+	Definition: Plus Example. 10 + 11 Returns 21
-	Definition: Minus Example. 5-2 Returns 3
/	Definition: Division Example. 10/2 Returns 5
*	Definition: Multiply Example. 2*8 Returns 16

Parameter/Function	Description	Current Values
CHARGE_ELEMENTS	The derived value of the charge method
CHARGE_RATES	The derived value of the fee assessment rate

Variables	Description
Number	0-9

Syntax of Tax (GST) Rule

Operators	Usage
( )	Definition: Parenthesis Example. (6-4)/3 Returns 2/3 or 0.666666…
ROUND(<value>,decimal places)	Definition: Round a number to so many decimal places Example. ROUND((6-4)/3,2) Returns 0.67
TRUNC(<value>,decimal places)	Definition: Truncates a number to so many decimal places Example. TRUNC((6-4)/3,2) Returns 0.66
,	Definition: comma, used to separate operand from parameter in rounding and truncation functions above. Example. See above
+	Definition: Plus Example. 10 + 11 Returns 21
-	Definition: Minus Example. 5-2 Returns 3
/	Definition: Division Example. 10/2 Returns 5
*	Definition: Multiply Example. 2*8 Returns 16

Parameter/Function	Description	Current Values
AMOUNT	The amount on which tax is calculated

Variables	Description
Number	0-9

Last Modified on 11 February 2000