austin_ck

Calculation for each fields

Discussion created by austin_ck on Apr 20, 2014
Latest reply on Apr 20, 2014 by erolst

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.

Outcomes