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.
January Units Sold (this is the calculated field I am trying to create)
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.