7 Replies Latest reply: Feb 2, 2015 11:11 AM by Neena Bhattarai RSS

    My expression is not displaying the right results.

    Neena Bhattarai

      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.