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

    911 Calculated field help COUNTIF

    johnmotlagh

      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!