Prevent "Divide By Zero" errors

Alex Needham

Hello,

In a system with as many intersections as BOARD (or any multidimensional database), an administrator/developer cannot always guarantee an entry for a rate calculation.

Currently, the way to solve this is to calculate the rate by doing something along the lines of:

c=IF(b<>0,a/b,0)

However, in other systems (ie TM1) this is a baked-in functionality. It provides some performance boosts as it is one less "if" statement to have to evaluate on each intersection.

"/" - the traditional division
"\" - division with additional logic to prevent divide by zero errors

If this were to be implemented, the above statement would be simplified to:

c=b\a

...which will, hopefully, provide some efficiencies in how BOARD evaluates the expression on the backend.

Product Management Team

Thank you for sharing your insightful suggestion with us, Alex. Your time and effort are genuinely valued. 

While we're not proceeding with your idea at the moment, this decision is based on our updated product enhancement and idea lifecycle processes, introduced in 2023 (details in our Idea Exchange FAQs). 

https://community.board.com/kb/articles/1095-idea-exchange-faqs

Despite this, if you believe your idea still holds relevance, we invite you to resubmit it for review under the new guidelines. We're dedicated to offering the best user experience and prioritizing features and enhancements that significantly impact everyday usage of our software. 

Your input is crucial to our community, and we sincerely appreciate your participation. Please keep those creative ideas and feedback coming – we always look forward to hearing from you. 

Thank you again for your understanding and continued support.