Saved Search Formula SUM(averagecost}/{pricelevel2...
# administrationm
mightyd3
07/14/2021, 1:12 AMSaved Search Formula SUM(averagecost}/{pricelevel2}) and the entire column disappears from the results. Am I going crazy or should this work? Individually, averagecost and pricelevel2 will display just fine on the search.
mightyd3
07/14/2021, 1:59 AMfollow up to this. I can multiply the fields, but dividing not working???
a
AI1
07/14/2021, 2:09 AMTry using SUM({average cost}/NULLIF({pricelevel2}, 0))
m
mightyd3
07/14/2021, 2:09 AMlooks to be a cost/price issue.
mightyd3
07/14/2021, 2:12 AM@AI1 pretty much where I was going with this. I nullif'd both. and it works. Seems to bug out if either is missing the value.
a
AI1
07/14/2021, 2:19 AMUsually NetSuite requires a NULLIF for every denominator to eliminate the error of dividing by nothing
I’ve never heard of having to do the numerator as well but glad it works