Problem with Set analysis and Rank

Thu, 08 Nov 2012 11:56:45 GMT

When i change from 10 to 20, the top 10 value changes.

for example when i have the condition <=10 the values are

700

650

....

when I change it to <=20 it changes to

800

799

... etc

which should have been the case with my top 10 itself. Can't understand this behaviour.

This is my expression.

=if(aggr(rank(fabs(aggr(sum({<iss_crr={'EUR'}, fld1={'xx'}, fld3-={'cc1'}>} val1), ac_dec))),ac_dec)<=10, ac_dec)

Want to take the ac_dec with the top 10 values for the absolute sum of values of field 'val1' per ac_dec grouping. This is what i want to achieve.

Thanks

Ram

Re: Problem with Set analysis and Rank

perumal_41 — Thu, 08 Nov 2012 12:12:23 GMT

Hi Ram,

if possible upload sample application