Question

I am looking to get a basic difference between 2 columns?

+7

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

+7

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

+7

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

Sign up