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!
Filtering on Missing Pricing via Formula
Hello.
I have a Saved Search in which I have a formula field that is pulling one of our price levels.
Here's the formula:
NVL(TO_CHAR(CASE WHEN {pricing.pricelevel}='Customization' AND {pricing.minimumquantity}=0 THEN {pricing.unitprice} END),'No Price')
It's working great in the results:
[ATTACH=CONFIG]n356946[/ATTACH]
But when I add that to the Criteria as contains No Price I get a list of all items, even when they originally had a price:
[ATTACH=CONFIG]n356947[/ATTACH]
I've tried multiple combinations of formula (currency, number, text) and filtering styles (=0, empty, contains, etc) and am continuing to get this result.
0