Toggle select value with Set Analysis with AGGR

[james]

All,

I am able to select a field  called 'Item' using toggle select and the search string as follows

='=(sum(aggr(DISTINCT

if((Sum([Full Consumption])/Sum([Onhand USD])) <4.0,

Count( Item),0),

Item) ))'

However, once i try to introduce Set analysis into this expression, it wont render...

='=(sum(aggr(DISTINCT

if((Sum({$<Level_Flag= {'0'},Filter = {'1'}>} [Full Consumption])/Sum({$<Level_Flag= {'0'},Filter = {'1'}>} [Onhand USD])) <4.0,

Count( Item),0),

Item) ))'

any ideas on a workaround???

[swuehl · Accepted solution]

That's probably due to the single quotes in your set modifiers being misinterpreted.

Try

='=(sum(aggr(DISTINCT

if((Sum({$<Level_Flag= {0},Filter = {1}>} [Full Consumption])/Sum({$<Level_Flag= {0},Filter = {1}>} [Onhand USD])) <4.0,

Count( Item),0),

Item) ))'

or

='=(sum(aggr(DISTINCT

if((Sum({$<Level_Flag= {"0"},Filter = {"1"}>} [Full Consumption])/Sum({$<Level_Flag= {"0"},Filter = {"1"}>} [Onhand USD])) <4.0,

Count( Item),0),

Item) ))'

[james]

Yes the single quotes was the issue...

Thanks