Circular Dependency

[Anonymous]

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...

[Phil_Seamark · Accepted solution]

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.

[Anonymous]

@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.