AnsweredAssumed Answered

Calculation with Multiple Criteria

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

Hello,

 

 

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:

Item#

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

 

Table 2:

Item#

Units Sold

Year

Month

 

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.

Outcomes