Struggling With Expression - Two Different Tables

[pnn44794]

Hello All:

I'm struggling with an expression where it works fine in one table, but not another table where I need, effectively, the same expression executed.  I suspect I'm missing something simple.  This is in a straight table where I'm trying to do this.  For simplicity, I'll call the tables TableA and TableB.

This works fine in TableA.  In TableB, it only returns a blank column.  I'm guessing that I need to have at least one column related to both tables, but I'm struggling to come up with one (have tried multiple different columns).

TableA has columns Product, Q1, Q2, Q3, Q4 Consumed which are all expressions and which I'm trying to calculate for TableB, etc.

TableB has columns ProductGroup, DM #, order_date_quarter, =Table1_order_date_quarter = v2018ForecastQtr, =v2018ForecastQtr, and Product2018.

Does anyone have any ideas?  As always, thanks in advance for any and all help / responses.

[Anil_Babu_Samineni]

You may change Product / ProductGroup to maintain consistency each associate. Then, Try? Or share your model please

[pnn44794]

Thank you, Anil, for your response.  I believe you are correct and I'm looking into making a data model change.  I'm still having a bit of a mental block though because I think I've been looking at this for too long. 

What I didn't say above is that these different tables are from different sources and have different column names and I'm doing inline loads as well trying to compensate for that.

Right now, I'm manually entering values into variables and saving them.  I will work on getting the data model corrected.