AnsweredAssumed Answered

If calculation not working

Question asked by SamOsman on Jul 21, 2017
Latest reply on Jul 21, 2017 by Jaymo

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. 

Outcomes