7 Replies Latest reply on Jan 7, 2013 9:25 AM by Jonathan Drummey

    911 Calculated field help COUNTIF


      I need to create a calculated field that mimic excel's COUNTIF.


      I have customer service servey reports with a scale of 1-10.  I need to have separate calculations for

      9-10 - called NPS Promoters in the workbook

      7-8 and Called NPS Passive

      0-6 Called NPS detractors


      I would like to get a count of each group of numbers.


      My COUNT ([Q1]>9) gives me back the same count as COUNT([Q1])


      I hope someone is working on Sunday!