Forum Discussion

Sachy123's avatar
Sachy123
Helper V
7 years ago
Solved

Need Help , lookup value from another table

In my scenario, I have two tables Contract Hierarchy ID ParentID ChildID 1 1 6 2 1 7 3 2 8 4 4 10 5 2 9 6 4 11 7 5 12 8 3 13 10 5 14 and ContractDetails ID Contractnumber 1 ABC1234 2 ABC1235 3 ABC1236...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Sachy123,

     

    In my example I have the relationship with without bidirectionalty, using the both way filtering on relationships works in "stranges" ways.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
7 years ago
Hi Sachy123 Try the LOOKUPVALUE formula should be something like this: ParentContractNumber = LOOKUPVALUE( Contract[Hierarchy]; Contract[ParentID]; ContractDetails[ContractNumber]) This works like VLOOKUP on excel. Regards, MFelix
  • Sachy123's avatar
    Sachy123
    Helper V
    7 years ago
    So this formula c = LOOKUPVALUE(ContractHierarchy[ParentContractNumber],ContractDetails[ID],ContractHierarchy[ChildID]) fetches me nothing.. :( I need still the contract number of child contract in the hierarchy table..
    • Sachy123's avatar
      Sachy123
      Helper V
      7 years ago
      ** EDIT ** I used the following formula, but its still fetching me nothing = LOOKUPVALUE(ContractDetails[ContractNumber],ContractDetails[ID],[ChildID])