set analysis

[#1]

Where can i put a set analyses in this formula so that selections are ignored.  I tried everything but it don't seems to work  Formula:stdev(aggr(sum(XXX),y,y))  Wherever i put a set analysis selection the result still changes when making a selection.  Peter

[brenner_martina]

Hi, Peter,

I think the following is right:

stdev({<Field1=,Field2=,... >} aggr(sum(({<Field1=,Field2=,... >} XXX),y,y))

Field1= means, a selection in this field will not effect the sum and stdev

Greetings from Munich

Martina

EVACO GmbH

[jagan]

Hi,

Try using {1} in you expression.

stdev(aggr({1}sum({1}XXX),y,y))

{1} - disregards the selections

Regards,

Jagan.

[#4]

You should try :

stdev( {1} aggr( {1} sum(XXX),y,y))

Then your expression will be independant from all selections in your application.