on 03-05-2021 9:19 PM
Good afternoon:
I am trying to get an aggregated count per staff member of constituents who have completed at least one event in three difference categories.
I have three category calculations which are versions of the following
=Count([Program Touchpoints - All].[Subject Identifier] Where ([Program Touchpoints - All].[Form Element Choice ID] InList (25787;25788;25789;25790;25663;25664;25665;25666;25336;25337;25338;25339));Distinct)
I have a summary calculation which adds these three columns
=Sum([Count_Category_1] + [Count_Category_2] + [Count_Category_3])
and a conditional column for rows to include
=Count([Subject Identifier]) Where ([Sum_Category] = 3 in ([Subject Identifier]))
As long as the detail is include, the results are as expected
However, in the the summary output the v_Include value is null.
Without the subject detail, the [Sum_Category] element in the v_Include calculation is returning 35.
Thank you,
Steve
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.