Excluding Selections

[#1]

Hi

Not sure the easiest way to do this but i have this formula for calculating average CSi Score, for each wave and across all leasing companies.  I have a selection box for activity and i wanted this result not to be changed by selecting anything in activity field, any ideas ?

=avg({<Country= {$(vMarket)}, CSi={'>=0'}, tfs= {'>=$(vMinFleetSize)<=$(vMaxFleetSize)'}, section1Loop= {$(vLeaseCo)}, Wave={'$(vWaveCurrLC)'}, Activity= >} CSi)/100

Thanks for you help much appreciated.

Sarah

[anbu1984]

Activity= -- This will ignore any selection on Field Activity

Are you not getting correct result?

[ThornOfCrowns]

You can use <[SelectionField}=,> to ignore that field.

[#4]

When inside set analysis you do 'Field =' it will ignore any selections in that field. For your example your code should work.

[#5]

didn't seem to work tried both ways am i doing something wrong ?

=min(aggr(avg({<Country= {$(vMarket)}, CSi={'>=0'}, tfs= {'>=$(vMinFleetSize)<=$(vMaxFleetSize)'}, LeaseCo= ,<[Activity]= , Wave= {'$(vWaveCurr)'}   >} CSi),section1Loop))/100

[CELAMBARASAN · Accepted solution]

When using Aggr, you need to apply the set analysis to the outside of the expr too, like below

=min({<Country= {$(vMarket)}, CSi={'>=0'}, tfs= {'>=$(vMinFleetSize)<=$(vMaxFleetSize)'}, LeaseCo= ,[Activity]= , Wave= {'$(vWaveCurr)'}   >} aggr(avg({<Country= {$(vMarket)}, CSi={'>=0'}, tfs= {'>=$(vMinFleetSize)<=$(vMaxFleetSize)'}, LeaseCo= ,[Activity]= , Wave= {'$(vWaveCurr)'}   >} CSi),section1Loop))/100

[#7]

Thanks so much guys works perfectly !