nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

What's wrong with this Key Metric?

Stefano_Mazzocca

I tried both versions

Find more posts tagged with

Fusion AI Data Platform

Accepted answers

Benjamin Arnulf-Oracle

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)

All comments

Benjamin Arnulf-Oracle

The formula should be:

CASE WHEN condition THEN expression ELSE expression END

Stefano_Mazzocca

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

Benjamin Arnulf-Oracle

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)