Forum Discussion

mp390988's avatar
mp390988
Post Partisan
1 year ago
Solved

RELATED function not working despite a join

Hi,   I have this model:     I am trying to create a calculated column to bring in the DealerID from the Clients Table into my Payments Table.   But i get an error saying...
Need Help
  • shashiPaul1570_'s avatar
    shashiPaul1570_
    1 year ago

    mp390988  

    Glad that helped! 
    Yes, LOOKUPVALUE is a good alternative when RELATED doesn’t behave as expected, especially if the relationship setup is tricky. Just make sure the Clients[ClientID] column is unique, so you always get a single match.

    Happy reporting, and if this solved your issue, please don’t forget to give a Kudos 👍 and mark it as Accepted Solution ✅ so others can benefit too.

    Thanks
    Shashi Paul 

shashiPaul1570_'s avatar
shashiPaul1570_
Responsive Resident
1 year ago

mp390988  

Glad that helped! 
Yes, LOOKUPVALUE is a good alternative when RELATED doesn’t behave as expected, especially if the relationship setup is tricky. Just make sure the Clients[ClientID] column is unique, so you always get a single match.

Happy reporting, and if this solved your issue, please don’t forget to give a Kudos 👍 and mark it as Accepted Solution ✅ so others can benefit too.

Thanks
Shashi Paul