using search.lookupFields is it possible to get the actual value of a percent field (as opposed to the formatted version e.g. “0.0%“)? In this case I’d just want 0 --- I’m using it to set another percent field.

parseFloat

if you essentially just want to remove the

%

. Divide by

100

if you need the decimal value.

yeah this is what I ended up doing (parseFloat and divide)

In a full search, you could maybe work something out with a Formula column

Yeah, this is really just a one off “grab value from here and stuff it in there” thing. I usually just use SuiteQL these days but trying to be more standard NS where possible.