I have a summary criteria in a saved search that should exclude any amount that is equal to 0. However, NetSuite does not exclude the ones that are just rounded to 0.00 but is actually 0.001232 or something like that.
Is it possible to exclude even those amounts that are rounded to 0.00 but are not exactly 0?
w
Watz
03/12/2021, 9:51 PM
Make the summary criteria into a formula that is wrapped in round() or maybe it's enough for you to set it to not be between -0.005 and 0.005
l
Luis
03/13/2021, 1:24 AM
Between works only if there are two decimals
t
Tristan Day
03/13/2021, 9:59 AM
make the formula criteria "greater than" 0.004?
k
KevinJ of Kansas
03/15/2021, 9:50 PM
why not just throw a Round(formula) not equal to zero?
l
Luis
03/16/2021, 1:46 AM
It causes up to 0.05 rounding differences. We need to strictly zero out the sources.