aggr and set analysis

[#1]

In a textbox, why does the following give the result "alfa, gamma" instead of just "alfa" ?

=concat({$<Names={alfa,gamma}>}

          aggr({$<Names={alfa,beta}>}Names , Names

          ),',')

the Names table looks like this:

Names

alfa

beta

gamma

I cant get the aggr function to work with set analysis. I always need to put in another function like sum or concat to limit the data set with.

But the manual does say that sets work in aggr:

"By default, the aggregation function will aggregate over the set of possible records defined by the selection.

An alternative set of records can be defined by a Set Analysis (page 805) expression."

and

"aggr ([ distinct | nodistinct ] [{set_expression}]expression {,dimension})"

/help much appreciated

[fosuzuki]

Hi,

Actually I think your expression has an error. Inside your aggr() function there should exist a set expression like concat().

"aggr ([ distinct | nodistinct ] [{set_expression}]expression {,dimension})"

Hope this points you in the right direction.

Regards,

Fernando