Forum Discussion

paulalmond91's avatar
paulalmond91
Helper II
7 years ago
Solved

Relationships on Multiple Calculated Columns - Calculated Table Solution Help

I have a worksheet where I have a set number of activities. Against these activities, there is a calculated column that does a lookup to return an ID to find the latest assessor and latest employer. ...
Need Help
  • paulalmond91's avatar
    paulalmond91
    7 years ago

    jdbuchanan71 Had a bit of a revelation and realised the solution was quite simple. I was returning the ID value then trying to create a relationship on that ID.

    I've changed the calculated columns to return the actual name of hte assessor or employer (which is the information I want to visually display) and removed the relationships and now this works perfectly.

     

    Thanks for your help though!

paulalmond91's avatar
paulalmond91
Helper II
7 years ago

jdbuchanan71 Had a bit of a revelation and realised the solution was quite simple. I was returning the ID value then trying to create a relationship on that ID.

I've changed the calculated columns to return the actual name of hte assessor or employer (which is the information I want to visually display) and removed the relationships and now this works perfectly.

 

Thanks for your help though!

jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

Nice!  Glad you were able to figure it out and thank you for letting me know you got it solved.