Calculations

Calculations are performed on save (as an after-save routine).

From the inputs, we calculate based rates based on the old and new land values.

The outputs based on the new land values have 'new' at the start of the field name.

The input / calculation fields are as follows:

Field	Detail
RATES_FACTOR (Input)	New rates factor for the rate type as input.
RATES_FACTOR_INCREASE (Calculation)	([RATE_FACTOR] - [OLD_RATE_FACTOR]) / [OLD_RATE_FACTOR]
MINIMUM_CHARGE (Input)	Input the minimum charge for the rate type (if applicable).
BASE_CHARGE (Input)	New base charge for the rate type as input.
RATE_CHARGE (Calculation)	If ([RATE_FACTOR][CALCULATION_VALUE]) > [MINIMUM_CHARGE] Then ([RATE_FACTOR][CALCULATION_VALUE]) Else [MINIMUM_CHARGE])
MINIMUM_CHARGE_ASSESSMENTS (Calculation)	Count of assessments being charged the minimum charge based on the old land value.
TOTAL_RATES (Calculation)	[RATE_CHARGE] + [BASE_CHARGE]
TOTAL_RATES_INCREASE (Calculation)	([TOTAL_RATES]-[OLD_TOTAL_RATES]) / [OLD_TOTAL_RATES]
NEW_RATE_CHARGE (Calculation)	If ([RATE_FACTOR][NEW_CALCULATION_VALUE]) > [MINIMUM_CHARGE] Then ([RATE_FACTOR][NEW_ CALCULATION _VALUE]) Else [MINIMUM_CHARGE])
NEW_MINIMUM_CHARGE_ASSESSMENTS (Calculation)	Count of assessments being charged the minimum charge based on the new land value.
NEW_TOTAL_RATES (Calculation)	[NEW_RATE_CHARGE] + [BASE_CHARGE]
NEW_TOTAL_RATES_INCREASE (Calculation)	([NEW_TOTAL_RATES]-[OLD_TOTAL_RATES]) / [OLD_TOTAL_RATES]