How to divide with two calculated rows in an OLAP table?

Question

Hi Celopeers,

I want to make a calculation in an OLAP table, where I divide a COUNT value through a sum of COUNT values.

To be specific: I want to divide the SUM 1 which consists of all the cases related to a single operation through the SUM 2, which consists of all the cases related to a single operation that are classified as 'NOT CORRECT'.

The Sum of Changes is calculated through a COUNT statement.

Thanks for your help!

Page 1 / 1

You need to calculate the KPIs separately. Like KPISum1 = COUNT(whatever....) and KPISum2= COUNT(CASE WHEN Classification = 'NOTCORRECT) the 1 else 0...)

and then operate.

HTH

Reply

guillermo.gost12 · Answer

You need to calculate the KPIs separately. Like KPISum1 = COUNT(whatever....) and KPISum2= COUNT(CASE WHEN Classification = 'NOTCORRECT) the 1 else 0...) and then operate.HTH

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN