Skip to main content

Column 1 has values where the KPI is as such for a company 1 (after clicking calculate shares in percentage checkbox):

SUM(Days related to certain case numbers)/COUNT(DISTINCT (No. of cases))

 

Column 2 has values where the KPI is as such for a certain company 2 (after clicking calculate shares in percentage checkbox):

SUM(Days related to certain case numbers)/COUNT(DISTINCT (No. of cases))

 

Column 3 has the difference

 

Based on what I saw the values for column 1 and 2 are read in correctly, but the difference in column three is wrong

 

Any suggestions on this would really be appreciated

Found an answer!

I used the GLOBAL function around the count to get the specific count for that particular case

Using that allowed be to get the correct difference between the 2 columns


SUM(Days related to certain case numbers)/GLOBAL(COUNT(DISTINCT (No. of cases)))

 


Reply