Forum Discussion

ReadTheIron's avatar
ReadTheIron
Icon for Helper III rankHelper III
2 years ago

Circular dependency with three related tables

I'm trying to create a calculated column to essentially reproduce the result that I can easily get in a visual. "Equipment" and "Complete" are from AMPHistory, "Remedial Completed" is from CurrentAMP...
Need Help
dharmendars007's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
2 years ago

Hello ReadTheIron , 

 

Please Check if bidirectional filtering is enabled between the tables. If it is, and you don't need it for this specific calculation, disable the bidirectional relationship between AMPHistory and CurrentAMP in the EquipmentFiltered table. You can temporarily disable it to see if that resolves the circular dependency. If bidirectional filtering is necessary, you might need to introduce calculated columns or temporary tables in your formula to avoid the circular dependency..

 

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 

ReadTheIron's avatar
ReadTheIron
Icon for Helper III rankHelper III
2 years ago

Thanks for the suggestion! Yes, bidirectional filtering is enabled, but, as I mentioned, I need that for other visuals in the report. Also, I tried temporarily disabling it, and it didn't affect the circular dependency.