TB - totalConsumptionTolZeroCheck.xml
Checks This validator should be set up for specific Accounts where you want to check zero consumption on this bill and/or previous bill. It is advised to set up at Account Level rather than Organisation.
*Similar to TB - totalCosumptionTolYearZeroCheck.xml, which checks the previous 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 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 – bill zero, previous zeropass 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, previous non-zerobill has consumption |
| PASS if present bill = non-zero, previous bill 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 – bill non-zero, previous zeropass if this bill has consumption and previous bill has zero consumption |
| PASS if cons difference % fails but kWh trivial, below significance limit (ignored 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 |
Current Bill details
NEW SCREEN SHOT REQUIRED
Failure Prompt
NEW SCREEN SHOT REQUIRED
Explanation: NEW EXPLAINATION REQUIRED
Total consumption within % of previous years bill: FAILED - name of the validator
tolerance=20.00 - the tolerance set in the validator
upperLimit=71149.20 - the amount of the consumption in the previous bill, plus 20%. 59291 (previous years bills consumption) + 11858.20 (20%) = 71149.20 (upper limit)
totalConsumption=98999.00 - the total consumption in the current bill
lowerLimit=47432.80 - the amount of the consumption in the previous bill, minus 02%. 59291 (previous years bills consumption) - 11858.20 (20%) = 47432.80 (upper limit)
MinimumQueryValue=0.00 - the minimum value set in the validator
...
Explanation: - This example is where none of the options have been ticked, and there is no consumption on this bill, but there is consumption om the previous bill
Total cons within % of previous 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 bill 33.95994 kWh
bznz=0.00 - - 0 = not set in this validator, but if ticked, will pass if this bill has zero consumption and the previous bill has consumption
HiLimit=35.34606 - the consumption in the previous bill - 35.34606 kWh
bzz=0.00 - 0 = not set in this validator, but if ticked, will pass if this bill and the previous bill both have zero consumption
PrevCons=34.653 - consumption on the previous bill 34.653 kWh (therefore did not pass validation as the previous bill has consumption, it was not zero)
bnzz =0.00 - 0 = not set in this validator, but if ticked, will pass if this bill has consumption, and the previous bill has zero consumption
kWhDiff=34.653 - the difference between this bills consumption and the previous bills, 0 (this bill), 34.653 (previous bill) = 34.653
PresCons=0 - consumption on this bill - 0 kWh
However, if the Validator was set to PASS if present bill = zero, previous bill non-zero (bznz), then it would have passed.
An example would be if you did not want to be notified if an Account had zero consumption, even it if had consumption on the previous bill.
