Forum Discussion
Solved
Using OR in a RELATED calculated column - return value based on two related tables
Hi - PLEASE HELP!! :) i have two lookup tables connected to a data table. Both can get me the column i want in the data table (ie, INDUSTRY), but through different relationships. Can I use the OR fu...
So that's the approach i took, but i had to to do two calculated columns using RELATED and then a final column with an IF statement, saying if the answer is not satisfied from the first column, then use the second column.
So that's the approach i took, but i had to to do two calculated columns using RELATED and then a final column with an IF statement, saying if the answer is not satisfied from the first column, then use the second column.
sunb1 hey just curious, isn't my ans the accepted solution to your problem?