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

# Calculation for each fields

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.

• ###### 1. Re: Calculation for each fields

Here's one way to do it.

• ###### 2. Re: Calculation for each fields

Hi Erolst ,

Possible I sort by ID ? because if using date to sort it, that is small bug, for same day record  200 -200 = -200.

• ###### 3. Re: Calculation for each fields

Well, sort by primary ID, or maybe a creation timestamp - anything that can correctly tell a newer record from an older one.