Hello. I'm trying to create an item formula field for Quantity available but it shows the error. Could I know what's wrong please?

Create item saved search Result use only one field formula(numeric) Sum : {quantityavailable} Create item custom field Free form text Uncheck stored value In the Validation & Defaulting tab, select the name of the saved search created above in the Search dropdown.

@Marc I already have another field from saved search, but is it possible to use formula between those 2 fields?

not sure if it's not stored

not stored

yes so I don't think it's possible. But if you just want a field with the total quantity available on an item, the method I described works

@Marc Is it possible to sum quantity available of specific location please? I tried it but it does not work

If you use a criteria in your search yes but it’s not best practice I think by script its possible

that criteria didn't work

let me check that