Overview:
Vault Report contains a date calculation producing an unexpected negative value.
Root Cause:
A formula field calculation is used to find the difference between two date field values. The resulting numeric value is less than zero. The second field contains a value that is numerically greater than the first field, producing a negative result.
Solution:
When the first field value (field1) is numerically greater than the second field value (field2), the difference produces a positive number. When the value of field2 is numerically greater than the value of field1, the difference produces a negative value. The formula is working as designed.
Example:
Field1 (value) |
Field2 (value) |
Expression/Formula |
Result |
10 | 5 | 10 - 5 | 5 |
5 | 10 | 5 - 10 | -5 |
Related Documentation:
N/A
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.
Thank you