MIN-MAX trouble

There is nothing determining whether the specific categories will be a % or a $ - if by rule you mean something like "Doctors Office" will always be $. This will be subject to change, as I pull in different tables, the "Doctors Office" category may be $, or %.

Apologies if I misunderstood your question.