I would like to create KPI: pay on time exclude receive after due date and pay in 10 days from receive date.

Question

OVING_MAX(COUNT( DISTINCT CASE WHEN DAYS_BETWEEN ( "BSEG"."AUGDT", ${INVOICE_DUE_AT}) >= - ${BUFFER_LATE} AND ${VARIABLE_RELEVANT_INVOICES_FOR_OTP} THEN ${VARIABLE_INVOICE_IDENTIFIER} END) / COUNT(DISTINCT CASE WHEN ${VARIABLE_RELEVANT_INVOICES_FOR_OTP} THEN ${VARIABLE_INVOICE_IDENTIFIER} END ),0,0)

I would like to create second part of this KPI- below only standard pay on time PQL formula

Page 1 / 1

Hi,

Could you give us more details on what each part of this formula is doing, and which pieces you would like to be modified. This will enable us to better assist you with the issue.

Thanks,

DS Team

Reply

will.caste · Answer

Hi,Could you give us more details on what each part of this formula is doing, and which pieces you would like to be modified.This will enable us to better assist you with the issue.Thanks,DS Team

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