I have an expression that looks like this:
=Count(iif(Fields!isCorrectAnswer.Value > 0, Fields!examId.Value, Nothing))
It works, but it doesn't return the proper values.
The reason is that if an exam has a Multiple Choice Many Answer type of question, it will count each choice as one answer.
But I just want to count one of them as the answer.
So I would return 1 or 0 for:
True or False count would be 1 or 0
Multiple Choice count would be 1 or 0
Multiple Choice Many Answer count would be 1 (if > 1 then only count as 1) or 0
Is there a way to do this in an expression?
Thanks