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