To increase the bill amount by %

[mithunr40]

To increase the bill amount by % if last pay date < current date

 for next 7 days                 12.5%

 for next 10 days               15%

[Vegar · Accepted solution]

I would probably do this in the script, but it is possible to use it front end inside an expression as well

If(today()-LastPayDate >=10, //identify 10d or more

   BillAmount * 1.15,

   If(today()-LastPayDate >=7, //identify 7-10 days

      BillAmount * 1.125,

      BillAmount * 1.00 ) AS NewBillAmount