I have two tables:
They are linked as followed;
budget.budget_id = protocol.budget_mid
I am creating a calculation field in the Budget table and I need it to add some protocol charges if a protocol field = 1
If (protocol.include = 1) ; sum (protocol.chargeamount)
My result is that it adds ALL of the values of the charge amount and not the records where protocol.include = 1.
I even tried SQL but no success;
ExecuteSQL ( "SELECT sum(chargeamount)
\"Include\" = 1
GROUP BY \"Budget_MID\"
; "" ; "" )
This only gives me a ? as the result
Any light on a solution would be greatly appreciated.
Thank you all.