Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try
count(if(Attendance='Y',1) + count(if(Defects='Y',1)
It does not work. I actually tried that before but it gives me a '-'. Thanks for the reply though!
=Count(IF(Attendance='Y' AND Defects='Y', something))
my mistyping:
count(if(Attendance='Y',1)) + count(if(Defects='Y',1))
Massimo Grossi: That expression only counts the Y when both Attendance AND Defects =Y so in the Attachment above I only have 1 time where I have Y in both Attendance AND Defects so that's why I got '1' as a result from that expression. I want to count each 'Y' separate. Thanks for the reply though!
But this will return 5, not 6. Unless I got the requirement wrong (?)
The expression you have written counts each individual 'Y', which is what I needed!! Thank you so much!!! This worked! I feel very silly though. I have been working on this for a while and it was right in front of me!