7 Replies Latest reply on Jul 21, 2017 10:24 AM by Jaymo

    If calculation not working

    SamOsman

      Hi, I've got the following layout:

       

      Screen Shot 2017-07-21 at 15.42.17.png

       

      So all invoices for the customer get total up under "total invoices"

      All payments added to a job sheet for that customer show under 'JS payments'

      However, I want to the outstanding balance to show total invoice payments, take away JS payments. Only when the 'payment banked' box is ticked.

      At the moment, it takes away regardless, and when I add the if statement to the outstanding balance calculation, it only takes into account the first check box. I need it on an individual basis. So when I check the top 'payment banked' the outstanding balance should be £700.

       

      Is it a relationship issue causing this? I can't seem to work it out.

       

      Your thoughts and suggestions are appreciated.