You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Formula Returning -1 Instead of Error for Empty Data Calculation

edited May 26, 2025 1:58PM in Planning 2 comments

Summary:


Content (please ensure you mask any confidential information):

Hi Experts,

I need help troubleshooting a formula issue in my report.

Issue:

Formula: Column B / Column A - 1
Unexpected Behavior: When both Column A and B are empty, the formula returns -1 instead of an error.
Has anyone encountered this? How can I adjust the formula to handle empty values correctly?

Example:

Col A

Col B

Col C (Formula: Col B / Col A - 1)

Expected Result

0

0

#DIV/0!

System Result

0

0

-1

Thanks in advance for your guidance!

Best,

Jacky

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!