Formula not working

[Anonymous]

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

[m_woolf]

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,','))