Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
vdacanay
Contributor II
Contributor II

Set Analysis in Dynamic Expression?

This statement works:

  sum({$<[STATE]=>} MEMBER_COUNT)

It sums the member count ignore the selection in the STATE field.

This statement does not work:

$(='sum({$<[STATE]=>} MEMBER_COUNT)')

That above statement will ignore the set analysis and sum the member count of only the state selected.  Am I doing something wrong here?

I'm asking because ultimately I'm trying to get this expression to work

$(='sum({$<['&(vIndexOnField)>&'=>} MEMBER_COUNT)')

...where vIndexOnField a variable that is set to 1 of 50 possible fields that I may want to index my results against the full set

So, how do I get:    $(='sum({$<[STATE]=>} MEMBER_COUNT)') to correctly evaluate ignoring the selections made in the STATE field?  Shouldn't that evaluate the same as the first statement?

Thanks,

Vince

1 Reply
Anonymous
Not applicable

Vince,

This will work, I tried (assuming I got you question correctly):

sum({$<[$(vIndexOnField)]=>} MEMBER_COUNT)

Regards,

Michael