how much went in, came out and how much is left.
Hello everybody, again I ask you to help dear,
I have a system controller of a financial cash flow, incoming and outgoing money, and calculating the total entries I had in the day, and subtract the total outlets to know how much is left in the coffin.
I have a Record has fields (id, date, type, value). in the Type field is a radio button (Input or Output).
my difficulty is to get the total per day, how much went in, came out and how much is left.
how can i calculat record that has type="Input" then type="Output" then subtract them.
thanks for listening