1. From to Analysis > Select Information Library > Add an Ad-Hoc query
  2. Select Membership from the query view list 
  3. (Optional) In the center box, select Membership Program > Move drag to Include Records Where
  4. (Optional) Status from the center box > Move to Include records where and select Active from the drop down
  5. On the far left box select Membership Transaction
  6. In the middle > select Transaction date > Move to Include Records Where and enter the date range you are looking to filter on (i.e. if you're looking for all transactions after 1/1/2016, use On or After and enter it in)
  7. On the left Expand Membership Transaction > Revenue Application 
  8. In the middle > select Amount > Move to Include Records Where and set Equal to 0