Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 un...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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's avatar
Phil_Seamark
Microsoft Employee
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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.