In queries you can create a query to see if one criteria is greater than the other criteria. Let's say you want to see a list of people that gave less than half of what they gave for a different campaign. You would need to do the following.
1. Go in to the query tab. You can follow the same steps by the charges tab or the payments tab depending if you want to compare pledges or payments. You can also mix and match them too, for example to compare a pledge against a payment.
2. Select the campaign or any criteria. By the amount dropdown (1) choose campaign1. When finished selecting your criteria click on include. (You can also use the multiplier field (2). Lets say you want to check only whoever gave lass then half you would enter by the multiplier * .5).
3. Enter the second criteria that you want to compare with. By the amount dropdown (1) choose campaign2. When finished selecting your criteria click on include.
