Formula Returning -1 Instead of Error for Empty Data Calculation
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):
Tagged:
0