3 Replies Latest reply on Apr 20, 2014 3:08 AM by erolst

    Calculation for each fields

    austin_ck

      Hi Filemaker User,

       

      I'm newbies to Filemaker,

       

      Attached the photo for explaination.

       

      How going to set the sub total to be calculate ?

       

      I need the calculation :sub total = Previous sub total + Add.Quantity - PO.Quantity

       

      Example : 18/04/2014 Sub Total (999) = Add.Quantity (999)- PO.Quantity (0)

      19/04/2014 Sub Total (799) = Perviosult sub total (999) +Add.Quantity (0) - PO.Quantity (200)

      20/04/2014 Sub total (599) = Perviosult sub total (799) +Add.Quantity (0) - PO.Quantity (200)

       

      Photo excel attached.