Community Says: Formula Debugging

Community Says is a new ongoing series spotlighting some of the insights, advice, and information posted by our Community members.

This week, we're spotlighting Partner, Master Anaplanner, and Community Super Contributor PaulRitner of Accelytics!

In a recent forum conversation about debugging formulas (specifically, how to know what's happening in a formula), he wrote:

Often I'll paste the formula into a text editor...add carriage returns to make the reading of the formula easier, and then test pieces of it separately...

If I have time on the project, I'll go back and rethink very long formulas with a focus on simplification.

...there's almost always a simpler way in Anaplan; we just have to find it.


If this advice helps you feel free to save or share the quote with your network. You can also contribute your additional ideas about formula debugging by joining the original discussion.

More from Community Says:

Have you come across something in the Community that you feel would benefit other users (even if you're the one who posted it)? Be sure to add the Community Says tag to the post so that we can consider it for a future edition of this series!