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!
Marketing sub category
i have created marketing subcategories with the intent that we would be able to roll reporting up to the parent category.
But i am unable to see where i can select just the parent on a results column in my saved search. I had to use formula text field to even display the columns i need
Formula (Text) REGEXP_REPLACE({category}, '[:^].*', ' ') to display the Parent Category
and
Formula (Text) REGEXP_SUBSTR({category},'[^:]+$') to display the Sub Category
but I am still not able to set the parent category as a criteria or a filter. what am i missing?
Tagged:
6