Hi,
I have added a text box that is meant to count the number of forms submitted based on the form type and the admission ID.
This is the formula I have been using however it only counts 2 for one of the forms when there are 4 submissions under that submission ID for that type of form
Count(Distinct(Filter(nestForms, Title=Title7.Text), AdmissionsID))
Title is the Form type and Title7.Text is the name of the form which is listed in a gallery (if that makes sense)
Was wondering if you could help me out.
Two questions to get more info on your issue:
User | Count |
---|---|
164 | |
96 | |
78 | |
73 | |
59 |
User | Count |
---|---|
209 | |
167 | |
98 | |
93 | |
79 |