RE: Add a formula(numeric) as an available filter in a saved search

I want to use formula (numeric) as an available filter in a saved search. My search can be either a transaction or item search. I want to show the item name, a sum of the sales for it and how many times it was on a sales order. I have the search just fine but I have one for single lines and one for all transactions. I’d like to do it all on a single search. I referenced and,-January%2016%2C%202019&text=Saved%20Searches%20are%20a%20powerful%20tool%20to%20solve%20problems%20in%20NetSuite.&text=So%20the%20trick%20here%20is,as%20on%20your%20Criteria%20tab.

But I cannot get this to work. I have my formula(numeric) as a criteria and when I try to mark the formula as “show in filter region”, I am unable to do that.

My formula for single line transactions is: Formula (numeric) {totalamount}-NVL({taxtotal},0)-{shippingamount}-{amount} is equal to 0

raymondand4 Rookie Asked on September 4, 2020 in Saved Searches.
Add Comment
10 Answers

If this is correct, then it doesn’t work. 0 gets my single line but 1 gets zero results

RE: Add a formula(numeric) as an available filter in a saved search

Rookie Answered on September 4, 2020.

I’m struggling to view the thread too so will continue in the comments…

So far we’ve tried “CASE WHEN {totalamount}-NVL({taxtotal},0)-{shippingamount}-{amount}=0 THEN 0 ELSE 1 END”.

I can confirm that this works for me – I pasted exactly as above without any quotes around the one and the zero.

Blank returns no results and the others filter accordingly.

N.B. I ungrouped and added a Formula (Numeric) to the results to test before adding the grouping back in.


on September 5, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.