AnsweredAssumed Answered

[newbie] help with calculation

Question asked by NathanRidge on Jan 21, 2012
Latest reply on Jan 22, 2012 by Sorbsbuster

Title

[newbie] help with calculation

Post

Hello,

I am new to Filemaker so please forgive me for asking such a basic question. I am trying to figure out how to do what seems to me a very simple calculation:

I have two tables, A and B. A has a field A::x, of type Number, and B has a field B::x, also of type Number.

Now I would like to add a field A::y, of type Calculation, where the calculation is "the number of records in table B whose B::x value is equal to the value of A::x in this A record".

Can someone tell me how to do this calculation? I tried to to " = Sum ( If ( B::x = A::x ; 1 ; 0 ) )" but it doesn't work, I just get a question mark as the value for the field.

Thank you for your help,

Nate

Outcomes