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 have this value from the savedsearch
```{
   values: {
      "SUM(formulanumeric1)": "3",
      "SUM(formulanumeric2)": "3"
   }
}```
i want to fetch 3, but am not able to do it. i had tried all means. coudl anyone please help? below is the code
search.createColumn({
                            name: "formulanumeric1",
                            summary: "SUM",
                            formula: "CASE WHEN {quantity}-{quantityshiprecv} &gt; 0 THEN 1 ELSE 0 END",
                            label: "Open Lines"
                        }),
                        search.createColumn({
                            name: "formulanumeric2",
                            summary: "SUM",
                            formula: "{quantity}-{quantityshiprecv}",
                            label: "Open Qty"
                        })

from your results did you try using
getValue({name: "formulanumeric1",summary:"SUM"});
?

Untitled.js

What I will often do for searches to simplify the process of working with columns is something like this snippet. Caveat here is that I typed this from memory and might have made a clerical error; the general approach is valid for sure.

Use labels when doing getValue or use getColumns and iterate through columns.

Since both the field are formula fields you need to use something additional beside the name, summary,join. Label comes handy in those cases.

<@U027PS9BDU2> the formulanumeric fields are named sequentially formulanumeric1/2/3/4 as long as the order does not change, you can reference them directly as I mentioned.
If the search is created in code and not being loaded, you're "probably" safe to reference them in this way.