Forum Discussion

Switto's avatar
Switto
Helper IV
6 years ago
Solved

if condition between two tables

Hello Everyone,   I am working on Time and Motion data which requires excluding the line items which are not aligned to Project TAT.   So I have a table which has data for day to day line items w...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    Switto - You will want to use RELATED or RELATEDTABLE or possibly LOOKUPVALUE and could also use MAXX(FILTER(...)...)

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Switto - You will want to use RELATED or RELATEDTABLE or possibly LOOKUPVALUE and could also use MAXX(FILTER(...)...)

Switto's avatar
Switto
Helper IV
6 years ago

Thanks for the tips 🙂 Let me read up and try to put into solution.

Appreciate your quick reply.