How to keep my variable fixed?

[#1]

All to you all,

Once more I need your advice…

I’m calculating an average value using this:

sum(aggr(sum(ac+dc),A))/sum(aggr(sum(ac+dc+dnc+anc),A))

this is put into a variable.

Now when is start making my selections, this value, obviously, changes and I like to make it stick with my original calculation prior my selection.

I’m not calculating this in the load script.

Set analysis maybe? Or any other simple way?

Thanks

[#2 · Accepted solution]

Hi,

If you don't want your calculation to depend on selections (if this is what you mean by 'original calculation') try this:

sum({1}aggr(sum({1}ac+dc),A))/sum({1}aggr(sum({1}ac+dc+dnc+anc),A))

[#3]

does the trick, thanks a lot

[CELAMBARASAN]

Aggr only does on the possible values of the given dimension.

Try this I think it will also be same as yours(Check it.I hope so )

(Sum({1}ac)+Sum({1}dc))/(Sum({1}ac)+Sum({1}dc)+Sum({1}dnc)+Sum({1}anc))