Trying to create a search that shows POs that incr...
# accounting
r
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}
k
You are going to have a really hard time with this one.
You might try wrapping those in a to_num
To_number rather