Skip to main content
Question

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

  • March 28, 2022
  • 1 reply
  • 8 views
.
Level 0

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

    1 reply

    W
    Level 0
    Forum|alt.badge.img+3
    • will.caste
    • Level 0
    • May 19, 2022

    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

    Community Code of ConductAccessibility statement