3 Replies Latest reply on Mar 25, 2020 1:19 AM by EA0708

    Saved Searches

    4164458

      Anyone know a formula I can use to capture only the variance of lines based on the columns in the screenshot below?  I am looking to capture only what is pending as you can see in the line where 1 unit was shipped but 0 received

       

        • 1. Re: Saved Searches
          Rado

          Hi,

          You can use in criteria

          Formula (Numeric): case when {field1} != {field2} then 1 else 0 end

          And then in the fields below choose equal and value 1.

          It's working for me In a similar case.

           

          Best regards

          Rado

          • 2. Re: Saved Searches
            4164458

            Hi Rado

             

            Unfortunately its throwing an error for me.  Perhaps because I already have a formula in the criteria.  Here is my criteria and results.  Maybe you can share what your search looks like with me and I take a different approach?  Sorry for the late reply.  I had an issue logging in.  Any help is appreciated

             

            criteria

            Results

            • 3. Re: Saved Searches
              EA0708

              Hi,

               

              I'm new to NS but I know a little about programming and I am doing some technical support on NS for less than a month now but no formal training in NS.

              Please correct me if I am wrong.

               

              Below is the formula(numeric) that Rado advised.  Please add them on your criteria

              Another suggestion is below

               

              EA