I know this is probably a knucklehead question, but. . . I have survey data including a question about how long the respondent has been in a program. See screen shot below.
I want to know, for given date range (see date filter), how many respondents chose each response option (see number of records in first column), what percentage of respondents chose each response option (see table calc, second column), and total number of respondents for the date range chosen. But, as you can see, the total number of respondents should be 50 for each row (the sum of all values in the first column) but it's not. I'm not sure where the numbers in the third column came from!
Here is my calculation for total number of records fixed by date:
I've also attached the workbook.
Thanks in advance for enlightening me!
-Amelia
Hi
You are faced with an order of operation issue
change the formul to this
then place the date in context to force the filter to be evaluated before the lod
and it will return this
jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
