AnsweredAssumed Answered

Calculation with selected Records from one Table

Question asked by TheGor on Jul 17, 2010
Latest reply on Jul 18, 2010 by TheGor

Title

Calculation with selected Records from one Table

Post

Hallo all,

I am new in Filemaker but have some experience in SQL but dont now how to do that in Filemaker.
I want to calculate some selected records inside a table see below.

Timestamp StationCode In Out
11.7.2010 0:00 62753 1267147 1178922
11.7.2010 0:00 62754 2042639 1963830
11.7.2010 0:00 62755 526172 575644
11.7.2010 0:00 62756 846324 814993
11.7.2010 0:00 62757 771005 732987
11.7.2010 0:00 62758 865027 873640
12.7.2010 0:00 62753 1269803 1181184
12.7.2010 0:00 62754 2042689 1964010
12.7.2010 0:00 62755 526172 575644
12.7.2010 0:00 62756 846424 814993
12.7.2010 0:00 62757 771211 733143
13.7.2010 0:00 62753 1270687 1183020
13.7.2010 0:00 62754 2042689 1964010
13.7.2010 0:00 62755 526172 575644
13.7.2010 0:00 62756 846424 814993
13.7.2010 0:00 62757 771231 733143
13.7.2010 0:00 62758 865027 873640

I WANT:
(In - Out) from 13.07.2010 and (In - Out) from 11.07.2010 where StationCode = 62753
(1270687 - 1183020) - (1267147 - 1178922) = -558

In my Layout i want to define Time Perion and Sation Code, how to get this working in Filemaker?


Thanks Igor

Outcomes