expression

[adiarnon]

hi,

i have an expression-

=COUNT({<Division={"=Aggr(Sum({<METRIC=,COMPONENETID={'49'}>}COMPONENTVALUE)/Sum({<METRIC=,COMPONENETID={'50'}>}COMPONENTVALUE)*100,Division)>70"}>}DISTINCT Division)

i have the value >70 in a field 'minvalue' how can i change the expression  to take the >70 from the field?

adi

[adamdavi3s · Accepted solution]

Ok give this a crack

=$(='COUNT({<Division={"=Aggr(Sum({<METRIC=,COMPONENETID={''49''}>}COMPONENTVALUE)/Sum({<METRIC=,COMPONENETID={''50''}>}COMPONENTVALUE)*100,Division)'&minvalue&'"}>}DISTINCT Division)')

[adiarnon]

tnx!!!

[adamdavi3s]

No worries, it was a fun challenge!

Please remember to mark any correct and helpful answers