Skip to main content
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

  • February 24, 2021
  • 1 reply
  • 74 views
.
Level 1
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

1 reply

K
Level 0
  • kevin.flesc
  • Level 0
  • November 9, 2021

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!!)...)

Community Code of ConductAccessibility statement