issue with Calculated measure

[#1]

Hi ,

I have one calculated measure (Avg TAT) for that we are using below definition , and the final result will be in Hours ,

(((Sum(TOT_INTR_MIN*60)+sum(PPS_anr_tat_hrs__c*3600))/count(distinct(if(UPPER(Status)='CLOSED' or 'COMPLETED',Case_Number,1))))/3600)

TOT_INTR_MIN--> values are there in Minutes(so converted into Sec.)

PPS_anr_tat_hrs__c--> values are there in Hours (so converted into Sec.)

while using that definition not getting exact value(please look at below highlighted values in the table)

VAEC	88.38
KOREA	43.57
SWEDEN	8,125.59
DENMARK	7,722.90
ISAREL	7,205.16
BELGIUM	6,730.11
FINLAND	6,404.13
SPAIN	6,397.94
FRANCE	6,038.79
SWITZERLAND	5,916.24

Can any one please help me here ?

Thanks & regards,

Sh

[hic]

You use the following condition, which isn't OK:

     UPPER(Status)='CLOSED' or 'COMPLETED'

Change this to

     Match(UPPER(Status),'CLOSED','COMPLETED')

HIC

[#3]

Hi Henric,

Thanks for the reply , I tried that what you suggested but now also facing like same issue

DENMARK	231.14
SWEDEN	196.69----->197.09
IRELAND	189.93------>190.33
NORWAY	183.98------>184.38

Is there any other way to get the exact result 196.69----->197.09(expected result) ?

Thanks & Regards,

Sh