Forum Discussion

StefRenneboog91's avatar
StefRenneboog91
Regular Visitor
5 years ago
Solved

Beginner level - Check if value is in table

Hey all, First of all, thanks a lot already for the one who is willing to help me. Let me describe the situation : I have TABLE 1 with COLUMN 1 = PERNR I want to create a measure where I check if TAB...
Need Help
  • nilimarodrigues's avatar
    nilimarodrigues
    5 years ago

    Hi,

     

    If you have one to one relationship between Table1 and Table 2, you could create a calculated column on Table1 with formula:

    If(PERNR = Related(Table2.PERNR),"1","0")

     

    Hope this helps.

nilimarodrigues's avatar
nilimarodrigues
Icon for Helper III rankHelper III
5 years ago

Hi,

 

If you have one to one relationship between Table1 and Table 2, you could create a calculated column on Table1 with formula:

If(PERNR = Related(Table2.PERNR),"1","0")

 

Hope this helps.