1 Reply Latest reply: Oct 15, 2018 1:58 PM by m w RSS

    Formula not working

    Ganesh Tavrigiri

      Hello Experts,

       

      I am using following formula to derive my KPI value

      if

      ((year(escalation_start_date)=year(period) and

      month(escalation_start_date)=month(period) and

      case_record_type = 'Case'),case_number)

       

      But it is giving me null value

       

      Please suggest any correction required.

       

      Thanks

        • Re: Formula not working
          m w

          Without seeing your data, I can guess.

           

          Your expression is returning more than one case_number.

           

          To see if I'm correct, try:

          if

          ((year(escalation_start_date)=year(period) and

          month(escalation_start_date)=month(period) and

          case_record_type = 'Case'),count(distinct case_number))

           

          If there are multiple case_numbers and you want to display a list, try:

          if

          ((year(escalation_start_date)=year(period) and

          month(escalation_start_date)=month(period) and

          case_record_type = 'Case'),concat(distinct case_number,','))