I am getting the error while creating the below KPI. Here KPI ABC_A/B/C is calculated KPI which uses SUM function.
CASE WHEN KPI(ABC Categorization by Reporting Currency) = A THEN KPI(ABC_A)
WHEN KPI(ABC Categorization by Reporting Currency) = B THEN KPI(ABC_B)
WHEN KPI(ABC Categorization by Reporting Currency) = C THEN KPI(ABC_C)
ELSE Vendor with no spend END
Page 1 / 1
Hi Ankita,
this can be solved by getting rid of the SUM() inside the KPI_A formula and putting it around the CASE WHEN. So your end formula would look like SUM(CASE WHEN KPI(ABC Categorization by Reporting Currency) = A THEN KPI(ABC_A)(!!without the SUM!!)...)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.