Hi,

I want to calculate the minimum of the following calculated column of an OLAP table:

SUM (CASE WHEN "Internal_Contol_BD_KPI"."RESULT_VALUE_2" = 'FAIL'

THEN "Internal_Contol_BD_KPI"."CONTADOR"

ELSE NULL

END) / SUM ("Internal_Contol_BD_KPI"."CONTADOR")

but when I try to apply MIN() to all that expression, the following error occurs: "Aggregate expressions cannot be nested inside aggregate expressions."

Then, how can I obtain the minimum of that calculated column?

I though a solution may be using PU functions, but since there is only one table in my analysis, it is not possible.

Regards