Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


TB - totalConsumptionTolYearZeroCheck.xml

Checks zero consumption on this bill and/or last years bill

*Similar to TB - tltalCosumptionTolZeroCheck.xml, which checks the previous bill.


NOTE:  Tenant Billing Validators need to be set up on the Tenant Account or Organisation (NOT the Site).

Validator Set Up


Variables

VariableDescription
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 – 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 , previous non-zeroconsumption 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 – bill non-zero, previous zeropass 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
 
If the user leaves the value as 0 then the bill would just FAIL on the breach of 10% (> 450)


Note: Previous 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

Image RemovedSCREEN SHOT REQUIREDImage Added


Failure Prompt

Image RemovedSCREEN 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

QueryValue=5956.20 - the monetary amount of the query. £14849.85 (current billed cost) - £8893.65 (previous years billed cost) = £5956.20 (the difference between the two)Image Added

Explanation:  - This example is where the Validator is set at 10 Tolerance and 600 kWh difference and no fields Ticked

This validator failed as the consumption on this bill of 4368 is NOT within 10% of the previous years bill of 35.205 AND there is more than 600 kWh difference


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

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=35.34606  - the consumption in the previous year's 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 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=34.653 - the difference between this bills consumption and the previous year's bills, 4368 (this bill) - 34.653 (previous bill) = 34.653

PresCons=0 - consumption on this bill - 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.

Image Added