TB - totalConsumptionTolYearZeroCheck.xml
Checks zero consumption on this bill and/or last years bill
...
NOTE: This Validator needs to be set up on the Tenant Account or Organisation (NOT the Site).
Validator Set Up
Variables
| Variable | Description |
|---|---|
| Tolerance % for consumption variation on previous year Tenant Bill, if both non-zero | Percentage variance allowed where current bill and previous bill consumption greater than zero |
| PASS if present bill = zero, previous bill = zero (bzz) | Select if validation should pass where both current and previous bills are zero bzz – pass if this bill and the previous bill both have zero consumption |
| PASS if present bill = zero, previous bill non-zero (bznz) | Select if validation should pass where the current bill is zero but the previous bill has consumption e.g. where property is now empty. bznz – pass if this bill has zero consumption and the previous bill has consumption |
| PASS if present bill = non-zero, previous bill zero (bnzz) | Select if validation should pass where current bill has consumption and previous bills are zero e.g. property was previously empty bnzz – pass if this bill has consumption and the previous bill has zero consumption |
| PASS if cons difference % fails but kWh trivial, below significance limit (ignore if 0) | Enter a kWh value that can be used if the validator fails but by a small amount e.g. Main tolerance set to 10% and 500 kWh significance limit: Current cons = 4975 kWh Previous cons = 4500 kWh Difference = 475 This fails 10% tolerance as 4950 is the limit, but passes as less than 500 significance limit |
...
Note: the Validator will look for an exact period match and if doesn’t find one, will use nearby bills to compare e.g. bill May -June 2022 which is compared against the Feb-Apr 2021 bill. Billing May-July compares the correct period.
Current Bill details
Failure Prompt
Explanation: - This example is where the Validator is set at 10 Tolerance and 600 kWh difference and no fields Ticked
...
Total cons within % of prev years Tenant Bill. PASS/FAIL on selected bill = zero criteria: FAILED
kWhLimit=10.00 -the 'Pass if cons difference%' figure in the Validator (last field) = 10 - 10 kWh
TolPcent=2.00 - the 'Tolerance' set in the Validator (first field) = 2 - 2%
LoLimit=33.95994 - the consumption in the previous year's bill 33.95994 kWh
...