Sigma Online User Manual

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

 GB – GasBandppu 

Compares the band rate on the current gas bill against the same band rate on the previous bill. 

Validator Set Up

Variables

VariableDescription
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???????????

  • No labels