Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Vince,
This will work, I tried (assuming I got you question correctly):
sum({$<[$(vIndexOnField)]=>} MEMBER_COUNT)
Regards,
Michael