Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Subtraction of {systemnotes.oldvalue}-{systemnotes.newvalue}ERROR: Invalid Expressio
Hello All,
I'm trying to do a simple formula calculation in a saved search which is subtracting one value from the other.
It's on the Client records and i'm using:
Formula(Numeric) with the following Formula
{systemnotes.oldvalue}-{systemnotes.newvalue}
The field value that is my oldvalue and newvalue is a custom field and is of Integer Type, so there is no reason why this formula should not work.
Error message received is:
ERROR: Invalid Expression
0