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!
Divide by Zero & Unexpected Error - Saved Search
Hi,
I have tried and tried again but keep getting errors. This is the formula I am trying to use this formula is looking at our qty which is a formula field and dividing the last 7 days sales.
min({custitem14})/ nullif(((Case when {transaction.account} = '1100 Sales' and ({today} - {transaction.trandate}) BETWEEN 0 AND 7 then decode({transaction.type}, 'Sales Order' , nvl({transaction.quantity},'0'),0) + decode({transaction.type}, 'Currency Revaluation', nvl({transaction.quantity},'0'),0) else 0 end) / 7),0)
If I split the formula - then both work but not when I join them. I have tried putting nullif in front of min, but still throw invalid expression. im sure i'm missing one small thing but right now :h_a_w:
0