TB - totalConsumptionTolYearZeroCheck.xml
...
*Similar to TB - tltalCosumptionTolZeroCheck.xml, which checks the previous bill.
NOTE: This Validator needs to be set up on the Tenant Account or Organisation (NOT the Site).
Validator Set Up
Variables
...
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 year's years Tenant Bill. PASS/FAIL on selected bill = zero criteria: FAILED
kWhLimit=60010.00 - the 'Pass if cons difference%' figure in the Validator (last field) = 600 10 - 10 kWh
TolPcent=102.00 - the 'Tolerance' set in the Validator (first field) = 10 = 10% 2 - 2%
LoLimit=3133.6845 95994 - the consumption in the previous year's bill 3133.684595994 kWh
bznz=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
HiLimit=3835.725 34606 - the consumption in the previous year's bill - 3835.72534606 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=3534.205 653 - consumption on the previous year's bill 35.205 kWh (therefore did not pass validation as the previous bill has consumption of 3.205)
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=433234.795 653 - the difference between this bills consumption and the previous year's bills, 4368 (this bill) - 3534.205653 (previous bill) = 433234.795653
PresCons=4368 0 - consumption on this bill - 4368 kWh 0kWh
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 year's bill.
