mightyd3
07/27/2021, 8:32 PMsearch.createColumn({
name: "formulanumeric",
summary: "MAX",
formula: "DECODE({inventorylocation}, 'Warehouse', NVL({locationquantityavailable},0))",
label: "Warehouse"
})
// getting the value
var warehouse = result.getValue({
name: 'formulanumeric',
label: "Warehouse",
summary: search.Summary.MAX
});