Forum Discussion

NBOnecall's avatar
NBOnecall
Helper V
6 years ago
Solved

Relationship Issue

Hi I have the following relationships active in my workbook. I am using Internal ID as the primary key.   I do not understand why the Average of SalesAmount and Averag of Rolling 30 days isn'...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Create a 4th Table called LocationID and then build a relationship from the LocastionID of the 2 Tables to the LocationID of this new table.  To your visual, drag LocationID from the new table.

    Hope this helps.

amitchandak's avatar
amitchandak
Super User
6 years ago

Please share the formula for rolling 30 and rolling 60

NBOnecall's avatar
NBOnecall
Helper V
6 years ago

I thought that might be the issue to, but even just selecting avg sale, still doesn't give the average per locationID