Forum Discussion

Pablo7777's avatar
Pablo7777
New Member
3 years ago

Match 2 tables by multiple columns (dates issue)

Hi, I have a two tables like below.   I need to calculate Total Costs for every Project. (hours spent * hourly cost) To do that I have to match these tables by multiple columns (Project I...
Need Help
Show and Tell
Tips and Tricks
Pablo7777's avatar
Pablo7777
New Member
3 years ago

Do you have another solution where there are more than 1 row per project in costs for any given date?

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    What additional criteria would you use to determine which row to use ?