Calculation Inconsistent Results

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.

Can you show us the ItemMaster table?

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.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.