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 l...
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"
)
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

     

     

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago
      Hi

      Did you try the above formula?
      • Kristofferaabo's avatar
        Kristofferaabo
        Helper IV
        8 years ago

        Yes, perhaps I misunderstand it, but it found 'find' the columns..

        I tried this:

        Column =
IF (
    OR (
        CALCULATE ( COUNTROWS ( TABLE B [Project] ) ) > 0,
        CALCULATE ( COUNTROWS ( TABLE C [PROJECT] ) ) > 0
    ),
    "Yes"
)