GB – GasBandppu
Compares the band rate on the current gas bill against the same band rate on the previous bill. Same as GB – ElecBandppuThreshold but for gas.
Validator Set Up
Variables
Variable | Description |
---|---|
Bill will pass validation if the Query Value is less than (£) | Enter a monitory figure, for example 100. The Validator will only fail if the value of the difference is above £100 |
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, the validator will fail |
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???????????