I have a summary criteria in a saved search that s...
# general
l
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
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
Between works only if there are two decimals
t
make the formula criteria "greater than" 0.004?
k
why not just throw a Round(formula) not equal to zero?
l
It causes up to 0.05 rounding differences. We need to strictly zero out the sources.