3 Replies Latest reply on May 8, 2018 7:24 AM by Dileep Reddy

    COUNT records where column = expression

    Jamie Irizarry

      I need to get the COUNT of all records in which ColumnX equals a certain value.  I tried doing COUNT(ColumnX = "Value"), but this does not return the correct count.  I do not want to filter the data where ColumnX equals this value, because I will be needing another column in the worksheet that shows the COUNT of where ColumnX = "AnotherValue".

       

      Thanks