Question
The aggregation function SUM cannot be used with a dimension function input. PLease check there are no aggregations and dimensions used together as function inputs
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
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!!)...)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.