This content has been marked as final.
Show 3 replies
-
1. Re: Count Distinct (CNTD) totals not equal to counts in spreadsheet - Workbook Version 2018.3
ShivaRam Chennapragada Nov 17, 2018 3:40 PM (in response to conacher)2 of 2 people found this helpfulHi, I think it's got to do with all the filters you applied. When I take them out, the numbers seem to match your spreadsheet results,
-
2. Re: Count Distinct (CNTD) totals not equal to counts in spreadsheet - Workbook Version 2018.3
conacher Nov 17, 2018 6:38 PM (in response to ShivaRam Chennapragada)Turns out I had Claimant Age field as a filter along with the Age Groups calculated field as a filter and the Claimant Age field filter was the problem. I don't know why but once that field filter was removed, the counts, as you said, were correct. Thanks for the lead that helped me find the answer.
-
3. Re: Count Distinct (CNTD) totals not equal to counts in spreadsheet - Workbook Version 2018.3
ShivaRam Chennapragada Nov 17, 2018 7:00 PM (in response to conacher)Glad I could help.