2 Replies Latest reply on Feb 4, 2013 2:13 PM by philmodjunk

    how much went in, came out and how much is left.

    HelderSantos_1

      Title

      how much went in, came out and how much is left.

      Post

      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