Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Try using {1} in you expression.
stdev(aggr({1}sum({1}XXX),y,y))
{1} - disregards the selections
Regards,
Jagan.
You should try :
stdev( {1} aggr( {1} sum(XXX),y,y))
Then your expression will be independant from all selections in your application.