Max/Min amount criteria in autocat works backwards with negative numbers

Yes, @jorgeelizondom, what @warren said is correct. We use absolute values in the min/max/equals AutoCat comparisons. This felt like the most straightforward way of dealing with charge polarity.

One thing you might consider if you want to take polarity into account is adding an AutoCat polarity filter. For example, add a column to your AutoCat rules sheet called Amount Polarity then add either Positive or Negative to the relevant filters.

I’m glad to see that you are using the advanced Autocat filters! :wink:

Randy

1 Like