What's wrong with this Key Metric?

Stefano_Mazzocca · Nov 22, 2024 2:55PM

I tried both versions

Benjamin Arnulf-Oracle · Nov 22, 2024 3:56PM

I believe Key metrics expressions must be measures.

Your current formula is resulting in a row-level calculation, not an aggregated value.

To fix it, you might need to wrap the formula in aggregation function like SUM().

Try:

SUM(CASE WHEN CAST(PER_ASG_PERCENTUALE_INCARICO_ AS INT) > 0 THEN 1 ELSE 0 END)

Benjamin Arnulf-Oracle · Nov 22, 2024 3:35PM

The formula should be:

CASE WHEN condition THEN expression ELSE expression END

Stefano_Mazzocca · Nov 22, 2024 3:45PM

Hi @Benjamin Arnulf-Oracle , unfortunately it seems not :(

MFA for Oracle Community