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!
Invalid expression attempting multiply opportunity fields
Hi,
I'm trying to take a couple fields, projectedtotal and probability to dynamically generate a value on Opportunities. I created a Transaction Body Field, Probable Sale, of type Free-Form text, and assigned it a formula. The formula I put in was:
{probability} * {projectedtotal}
However, I get "ERROR: Invalid Expression" in the field. Is there something I'm missing? I thought the formula was fairly straightforward.
0