This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I am trying to write a CASE statement for a Formula field in a Saved Search, but cannot get the logic right.

I need to compare two fields A and B. The search should only bring back records where A and B are different.
Field A: Is numeric (dynamic field sources from another search, and only have values )
Field B: Is List/Record (stored value)

I presume I need to convert the List/Record value to Number?

Field A only has values '1' '2' or '3'
Field B is 'x 'y' 'z' (where 'x' has ID of '1')

So,
• I need to convert FieldB to a number (x=1, y=2, z=3) 
• Then, if FIELDA &lt;&gt; FIELDB, then do something

yeah cast the id to a number and compare that