...
...
GB – GasBandppu 
| Excerpt |
|---|
Compares the band rate on the current gas bill against the same band rate on the previous bill. |
Same as GB – ElecBandppuThreshold but for gasThis Validator will fail if there is a difference (higher or lower) than the previous bill.
Validator Set Up
Variables
| Variable | Description |
|---|---|
| Bill will pass validation if the Query Value is less than (£) | Enter a monitory figure, for example 10010. The Validator will only fail if the value of the difference is above £100£10 |
| Unit rate change threshold (p) )e.g. 0.0001) | Enter a value that you want the Unit rate difference to fail if over. For example, enter 0.01 and if the difference between this bills and the previous bills ppu is more than 0.01, 01p the validator will fail |
Bill Entry screen
Failure Prompt
I have saved a bill on trainingacademy database, Account called Val2, invoice number called gasbandppu
The ppu is 5.6 on the current bill, and 2.86 on the previous bill. I have put really high consumption in the current bill so that the difference would be over £100 (as that is what is in the validator) :
BUT IT DOESNT FAIL???????????
...
Current Bill
Previous Bill
Failure Prompt
Gas unit rate has changed from the previous invoice: FAILED - the name of the Validator
'threshold=0.01' - the threshold set in the validator,, allowing 0.01p high or lower than the previous bill
'previous=2.50' - the figure in the Cost rate field (19854) in the previous bill
'MinimumQueryValue=10.00' - the minimum cost of the query, £10.00
'QueryValue=26.42916' - the difference (in £s) between charging the current units at 2.70 (current cost) and 2.50 (previous cost), ie 13214.58 x 0.20 (the difference between 2.50 and 2.70) = £26.42
'present=2.70' the figure in the Cost rate field (19854) in the present bill