Discussions
Is there a suggestion already to improve search criteria?
A number of times I have thought how useful it would be to be able to select the value of a field in the Value box for a search criterion. For example, I am trying to find orders where the sum of their deposits does not equal the order total.
It's a real pain to do it, requiring some messing around with formulae and, I think, use of some non-standard methods, like a summary function in the formula itself. I think it can be done and I'll keep trying, but this would be so easy if I could just do a summary criterion that sums the applied transaction total amounts and checks if the value is the transaction total. Instead, I have to give a specific number as the value, as though every transaction I might ever want to look at has