[newbie] help with calculation
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,
The logic you are using in the If ( B::x = A::x ; 1 ; 0 ) should be in a relationship between the two tables. So, one way would be:
- set up a relationship, Table A to Table B, matching those two values
- in Table A set a calculation, Count ( ThatRelationshipName::SomeFieldInTableBThat IsAlwaysCompleted )