Anyone ever seen this before? I am a bit lost.
# suitescript
m
Anyone ever seen this before? I am a bit lost.
b
m
@battk that worked.
thank you. just now I just need to kind rebuild this
b
its usually best to reuse your column used in the search
Copy code
var battkWroteMe = search.createColumn({
    name: "formulanumeric",
    summary: "MAX",
    formula: "DECODE({inventorylocation}, 'Warehouse', NVL({locationquantityavailable},0))",
})