Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Helper IV
8 years ago
Solved

lookup between tables

Hi!
I have a table which is linked to two tables thorugh the same relationship: "Project number"

 

I now want to make a column which returns 'Yes' if the given project number is in either of the linked tables.

 

Makes sense?

Krsitoffer

 

 

Need Help
Show and Tell
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI Kristofferaabo

     

    Try this COlumn

     

    Column =
IF (
    OR (
        CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0,
        CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0
    ),
    "Yes"
)

9 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    HI Kristofferaabo

     

    Try this COlumn

     

    Column =
IF (
    OR (
        CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0,
        CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0
    ),
    "Yes"
)
    • Kristofferaabo's avatar
      Kristofferaabo
      Helper IV
      8 years ago

      Hi,

       

      Zubair_Muhammad thanks for your input! always a pleasure! 

       

      Below is by relationships, table A, B and C all have the column 'Project'. I would like to be able to have column in table A indicating whether the project is also present in table B and C. Either with a Yes, or 1 or similar..

       

      That way I can filter it off/on

       

      Thanks

      Kristoffer