Linked table not returning correct value

I've attached what appears on the tables for the NL formula below which is not returning the correct value. I tried checking the knowledge DB but couldn't find anything that would give me the correct solution.

I want the formula to pick up the correct PBN based on the set “EXP_DATE” of 1/31/16 so that I can get the correct “PREMIUM” of $29.00. The formula below is giving me a “PREMIUM” of $19.33. The common factors in the two tables are the “GRP_NBR”. What is the correct link formula to return the correct premium?


Please sign in to leave a comment.