Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Circular Dependency on lookup calculated column

Here is the process I am trying to attempt:

 

LookupValue from Table A to place value in table B

Calculated column off of new value in table B to say if = Y, 1 - this is a trigger I need to calculate

Calculated column to add ALL triggers together from the entire table for a total.

 

I receive circular dependencies with the last 2 columns. I have attempted just one of them and still receive dependency. 

Please help

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I think it may have been the way I was trying to use the data & the relationship. I removed the relationship from the look up table and unique key and then did a lookup column by column into the main table. It then let me do the calculations properly. Not sure if it's the best way but it worked

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I think it may have been the way I was trying to use the data & the relationship. I removed the relationship from the look up table and unique key and then did a lookup column by column into the main table. It then let me do the calculations properly. Not sure if it's the best way but it worked