Forum Discussion

moshiera's avatar
moshiera
Frequent Visitor
8 years ago
Solved

True/False IF statement on two different tables

Let me explain what i'm trying to do and maybe there is an easier way of doing this...   Table: Vulnerability Vul      System x2123     xyzlaptop x5252    xyzlaptop x1235    abclaptop x3421   ...
  • Vvelarde's avatar
    Vvelarde
    8 years ago

    moshiera

     

    Hi, assuming that both tables are related.

     

    New Calculated Column: 

     

    Disabled = IF(COUNTROWS(RELATEDTABLE('Disabled System'))>0,"Yes","No")

     

    Regards

     

    Victor

    Lima - Peru

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi moshiera,

Please create relationship between the tables if there is no connection. Then follow the solution Vvelarde posted, please give feedback when there is other issue.

Thanks,
Angelia