SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I would like to get an average number of a data that has been filter by date range. however instead of getting the avg for display date range it calculate all the number in the database:


database: 1+2+3+4+5

after filter by date range: 1+3+5

Avg should be = 1+3+5/3 i/o 1+2+3+4+5/5

can anyone help..



share|improve this question
-1 This is one of the worst questions I've seen here so far. You don't provide any context other than tagging with "Infopath", but even that does not shed any light on the situation. If you want help with a problem, you need to make it easy for people to help you, not post a riddle. Provide the context. We cannot see your screen. We cannot look inside your head. Over to you. – teylyn Apr 25 '13 at 11:02
how are you getting the average? Where are you performing the calculation? – David Lozzi Apr 25 '13 at 14:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.