Vault Report contains a date calculation producing an unexpected negative value.
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.
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.
|10||5||10 - 5||5|
|5||10||5 - 10||-5|
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.