Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

LOOKUPVALE Formula stopped working

So I have this calculated column where I am using the LOOKUPVALUE formula to bring the record field text to another table (pretty basic). It was working fine, but suddenly now the calculated column i...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

     

    So I found the issue! I brought in a new data source (table called New Writer Master below) and when i created the relationship with my master Territories table I didnt noticed that it defaulted to Cross filter direction both. Once I changed this to single it worked again!

     

    Thanks Vivran, your comment sparked the idea to look there. 

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     

    So I found the issue! I brought in a new data source (table called New Writer Master below) and when i created the relationship with my master Territories table I didnt noticed that it defaulted to Cross filter direction both. Once I changed this to single it worked again!

     

    Thanks Vivran, your comment sparked the idea to look there.