Forum Discussion

randeep's avatar
randeep
Icon for Helper I rankHelper I
6 years ago

Conditional join on multiple columns

I have following model, which are imported into my project.     I would like to either have COGS field from Stock On Hand into Net Forecast or vice versa, by connecting product and date fiel...
Need Help
randeep's avatar
randeep
Icon for Helper I rankHelper I
6 years ago

amitchandak  I wish it was that easy. ğŸ˜€
You see there is no direct relationship established in between Net Forecast and Stock On Hand table. There is intermediarry table here, which is required too.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

randeep , you do not have a stock status table?

  • randeep's avatar
    randeep
    Icon for Helper I rankHelper I
    6 years ago

    Yes, but the relationship between Stock Status and Net Forecast on Product field. And Stock Status and Stock On Hand on Product field.

    The Date field is connected to Calendar table.

    When I use you proposed formula, it just sums up entire table.