Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

A Circular Dependency

When building this formula, I've gotten this error:   But I'm just lost on why this is happening and how to fix it because this formula doesn't depend on NPS Bonus so I don't know why it's ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi v-piga-msft I've since then figured out the answer to my own problem. I'm still not sure how or why it works, but another user suggested using Switch statements instead of nested IF statements and it ended up working. Didn't change anything about the logic at all:

     

     

     

     

    It works now, I'm just confused on when and why to use SWITCH vs. IF. I'm using nested IF statements on a different dashboard with the exact same formulas and they work fine.

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Anonymous,

 

You could have a reference of this similar thread which has been solved.

 

If you still need help, please share some data sample and your formula, so that we can help further investigate on it?

 

Best Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-piga-msft I've since then figured out the answer to my own problem. I'm still not sure how or why it works, but another user suggested using Switch statements instead of nested IF statements and it ended up working. Didn't change anything about the logic at all:

 

 

 

 

It works now, I'm just confused on when and why to use SWITCH vs. IF. I'm using nested IF statements on a different dashboard with the exact same formulas and they work fine.