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!
Compare two fields one being a formula (text) fields in my saved search
Ok so i have read a lot of threads on here but nothing has helped in what i need and im not even sure its possible.
So i have a saved search with the following criteria:
Criteria =
Type is Sales Order
Region is EMEA
Customer Catergory is End User
Results =
Number (Summary Type - Group)
Name (Summary Type - Group)
Line ID (Summary Type - Count)
Formula (Text) (Summary Type - Count)
So what i need to do is say that:
if the (Count result of Line ID) = (Count result of Formula (Text)) then 1 else 0 show only 1's.
So i have seen some post but everything is against custom fields and not a formula text field. Can anyone help:h_a_w::h_a_w::h_a_w:
0