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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
If/Then formulas supported by Search?
Can you use an if/then statement in a formula field in a saved search?
We have different cost structures and for one particular cost structure, we need it to show as the unit rate *1000. However, for other costs structures, we would just show the rate. We have a custom column field called "Cost Type". I want a report that shows all transactions but depending on the cost type either shows the rate as is or multiplies it by 1,000.
This formula returns an "Invalid Expressions" error:
if({custcol_cost_type}=CPM,{rate}*1000,{rate})
And this one returns a "Field not Found" error:
0