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

Vvelarde's avatar
Vvelarde
Community Champion
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