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!
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Saved Search - using formula (text) from results as available filter
Hello,
I have a saved search with one of the output column (custom label = Cust Type) as formula (text) = case when {customer} = 'XYZ' then 'Premium' when {customer} = 'EFG' then 'Standard' else 'Other' end
I would like to add Cust Type as part of Available Filters with the option 'Show in Filter Region'.
I added Criteria with the same Formula (text) as above and in the available Filters added Formula (text) with Custom label as 'Cust Type' and Show in Filter Region checked.
The filer region shows correctly with available values, however when select Any of the values (Premium or Standard), the results after refresh remain the same and does not really filter the output.
0