Trying to create a search that shows POs that increased by more than $1000. This isn't working:
Type is Purchase Order
Main Line is true
System Notes : Field is Total
System Notes : Date is within this business week
Formula (Numeric) is greater than or equal to 1000 {systemnotes.newvalue}-{systemnotes.oldvalue}
Getting this error:
Your formula has an error in it. It could resolve to the wrong datatype, use an unknown function, or have a syntax error. Please go back, correct the formula, and re-submit.
Search: Transaction Search
Formula: {systemnotes.newvalue}-{systemnotes.oldvalue}