Running into a strange scenario when I'm trying to pull values into a calculated column from another table. It seems to work fine... but not all the time and a number of values are missing although some appear correct without issue.
As you can see in my table I'm using this formula in to retrieve from 'POS Flyer Event Costs', it retrieves the correct value of $6.65 only once and leaves blank all the other rows where I would expect to see it as well.
A Snapshot of my tables:
POS Sales Data_Basic
POS Flyer Event Costs
Thoughts? Thanks in advance.
EDIT: I think something went wrong with the screenshots, just updated them.