Skip to main content

Hi all, I have a small problem with the calculation of the minimum variants depending on the company codes. My goal is to display the minimum number of variants as KPI. With my formula the number differs significantly compared to the KPI("Number of process variants") function. I think I need to add a distinct, but I don't know how exactly to do it. 

 

Here is my code:

 

MIN(

  PU_COUNT(

    DOMAIN_TABLE("VBAP"."BUKRS"),

    (

      SHORTENED(

        VARIANT("_CEL_O2C_ACTIVITIES"."ACTIVITY_EN")

      )

    )

  )

)

 

Kind regards

Ilker

Ohh well, i found the solution by using PU_COUNT_DISTINCT....


Reply