Forum Discussion
Circular Dependency
How does one go about troubleshooting where/why a circular dependency is happening and how to fix it? I get an error message that lists the columns involved which is nice but it doesn't help me in understanding how/why these two columns are bumping heads:
Neither one of these formulas reference nor depend on each other for any calculating so I don't know what the issue is...
Hi Anonymous
For a start, I would change to use the SWITCH function over your use of nested IF statements. This will make it easier - and I recommend formatting your calculation.
Once you have this, you can comment sections of the function to help isolate and quickly identify which part is causing the issue.
2 Replies
Hi Anonymous
For a start, I would change to use the SWITCH function over your use of nested IF statements. This will make it easier - and I recommend formatting your calculation.
Once you have this, you can comment sections of the function to help isolate and quickly identify which part is causing the issue.
Phil_Seamark thank you! I'm not sure how it's working under the hood but changing my NPS Bonus from a nested if to a switch made the circular dependency disappear.