Issue using Aggr Along with SET Exclusion

[nvrphanikumar]

@I have this below expression in the Dashboard,which is working.

Sum({$<[JO Status]={"010 Open"}>} aggr( OPENINGS_CNT,[Job Opening ID]))

I would like to make changes to this such that,When other Values are selected on JO Status,I would like the metric to not change.

Sum({$<[JO Status]=,[JO Status]={"010 Open"}>} aggr( OPENINGS_CNT,[Job Opening ID]))

I cant get this to work

When I don't use Aggr, This calculation below works,It doesn't take filter selctions on JO Status.

Sum({$<[JO Status]=,[JO Status]={"010 Open"}>} OPENINGS_CNT)

Not sure if I have to code it different when using Aggr,Can someone please help ?

[stigchel]

Try with

Aggr(Sum({$<[JO Status]={"010 Open"}>} OPENINGS_CNT),[Job Opening ID])

[nvrphanikumar]

Since,I have this definition in KPI,Its expecting sum values

so ,I tweaked your code to below,but this isn't getting me right numbers either.

sum(Aggr(Sum({$<[JO Status]={"010 Open"}>} OPENINGS_CNT),[Job Opening ID]))