Calculation Inconsistent Results

[Vinced4282]

Not sure why this calc isn't working. The first image is what I want:

This works:

So does this:

So I am confused as to why the first on is failing. I must be doing something wrong.

[AndrewB]

Can you show us the ItemMaster table?

[AndrewB]

Oh, I think I see it. Try adding another column reference to your THISROW() formula.

In your 3rd example, you're looking for a match against the string "Bison", but in the 1st screenshot, you're looking for a match against a rowlink, whose first column value is "bison".

So your formula would need to be something like this:
=findrow(itemmaster, "itemmaster[model]=%", [model][name])[cost]

Replace 'name' with the name of the first column in the ItemMaster table.