This content has been marked as final. Show 7 replies
I have two fields Attendance and Defects. I am trying to count each 'Y' in both fields. The expression I wrote:
Count(IF(Attendance='Y', 1 AND Defects='Y',1))
It is not counting each 'Y' it seems to be ignoring the second 'Y' if it appears in the same row. I have included attachments below of my chart and my data model. In the attachment below I am supposed to have 6 Y not 5 Y. Any help is appreciated.