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!
Need Help for Formula for Saved Search
I have a saved search for a custom record with the following on the result tab:
1) Country - Group
2) Formula (numeric) - Sum decode({custrecord_pr_process_step},'Created',1,0)
3) Formula (numeric) - Sum decode({custrecord_pr_process_step},'Package Sent',1,0)
4) Formula (numeric) sum decode({custrecord_pr_process_step},'Created',1,0) / nullif(decode({custrecord_pr_process_step},'Package Sent',1,0),0)
The first 3 are fine - it's the last one that throughs an error. I am not sure what I am doing wrong here. Any help would be much appreciated.
Regards,
Yen
0