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
Thank you