Skip to main content

Celonis Product Documentation

Example: Referencing the Base KPI
 - id: NET_SALES_VALUE_SINGLE_SUM_12M_BASE   
   displayName: Net Sales (Val, 1y)   
   description: This kpi sums up the total sales value over the last year across all materials and plants. It takes the value from the NETWR field in the Sales order item table (VBAP) and converts it into the target currency.   
   pql: |     
        KPI(       
            NET_SALES_VALUE_SINGLE_SUM_VARIABLE_TIMEFRAME_BASE       
            ,12       
            ,1     
        )   
    unit: " ${{to-currency}}"   
    format: .3s   
    parameters: []   
    desiredDirection: INCREASE   
    priority: false

Item

Description

NET_SALES_VALUE_SINGLE_SUM_VARIABLE_TIMEFRAME_BASE

Referenced inside another formula or KPI by wrapping KPI() around the ID.

Parameters

Upper limit of 12 ensures the SUMs lower limit goes as far back as 12 full months into the past).

Lower limit of 1 ensures the SUM ends upper limit goes back 1 month into the past, ie. the last closed month.