AnsweredAssumed Answered

Calculation with Multiple Criteria

Question asked by ZoltanOrban_1 on Dec 1, 2016
Latest reply on Dec 2, 2016 by jdevans




I have two tables and I am trying to add a calculated field to table one and look up the value from table 2 when 2 criteria is met. I cannot get the right value no matter how I try.


Table 1:


January Units Sold (this is the calculated field I am trying to create)


Table 2:


Units Sold




The relationship between the tables: Table 1: :Item# = Table 2: :Item#

I am looking for the Units  Sold where year = 2016 and Month = 1



How can I accomplish that?


I am running FileMaker Pro Advanced 14.0.2 on Windows.