I am trying to create a survey. And the survey has 4 options for each question A B C D.
For A its 1, B is 2, C is 3, and D is 4. Each is summed for a total across all the fields in a record giving a total for each record.
What I want to do now is count the number of As, Bs, Cs and Ds across the record and I can’t seem to do that ;-(
Should be something like sum if Field 1 = 1 and Filed 2 = 1 and Field 3 =1 …
And then another with Sum if Field 1 = 2 and Filed 2 = 2 and Field 3 =2 …
And so on for each record so I get the total number of A, B, C and D.
But I cant seem to do that does anyone have any idea how I can do this?
Thanks in advance