Calculation Field isn't calculated
I'm sure there's a ridiculously simple reason why I'm not getting a result for this calculated field:
The Stock Value field should be taking the Units on Hand (calculated field, unstored and displaying correctly on the layout) multiplied by the Price Retail Tier 1 (aka Price) field from the Products Pricing table. Here's my formula:
Units on Hand * Products Pricing::Price Retail Tier 1
The Price field is showing on the layout too - I'm referencing it directly from the Products Pricing table. Since I see the value on the layout, I'm assuming the relationship is set up properly.
What am I missing?