Query shows incorrect results when filtered on Batch number field

When an operator of "Greater than"  or "Greater than or equal to" is used to filter on a specific Batch number in an Ad-hoc Query, results display that are less than the Batch number entered as the filter. 
Batch number is a string field, so Altru treats batch number like a text field rather than a numerical field.  This is because batch numbers can have letters in them.

Therefore, if your criteria is batch number greater than 276, Altru may also pull in revenue in batches with batch number 3, 4, 5, 6, etc, as it is only looking at the first value in the string of batch numbers, rather than the number as a whole.

Instead of using the "greater than" operator in query, set your criteria to batch number is between, is equal to, or one of to get more accurate results.

Steps to Duplicate

  1. In Revenue > Batch Entry, add a membership dues batch.
  2. Enter data into the batch.
  3. Save and close the batch.
  4. Commit the batch.
  5. Go to Analysis > Information Library, and click create a new Ad-hoc query.
  6. Choose the source view of Memberships and click Ok.
  7. Expand Membership Transaction, expand Revenue Application, and highlight Revenue Details
  8. Move the Batch number field over to Include records where and set it to Greater than [a batch number one less than your batch number].
  9. Add the Batch number field as an output field
  10. Select Preview results and note that results are being included that have a Batch number less than the batch number in your query filter.

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.