```search.createColumn({ name: "formulanumeric...
# suitescript
m
Copy code
search.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
});