re-use a calculated colunm

[mohamed_ahid]

hi

i want to have a max and min (max evolution and min evolution) value depending on a calculatd colunm (evolution) .

i tried all the expression of evolution  in my aggr function and it works . but when i use the name of evolution in my aggr function it returns 0 .

see the sample .

Thx for helping .

[#2]

What are you trying to show as Max evoluution? the largest value of the other columns?

Richard

[MK_QSL]

=Max({1}Aggr((sum({1<week= {">=$(=1)<=$(=9)"}> } value)-sum({1<week= {">=$(=10)<=$(=15)"}> } value))/(sum({1<week= {">=$(=1)<=$(=9)"}> } value)-sum({1<week= {">=$(=10)<=$(=15)"}> } value)),client))

[mohamed_ahid]

but why i can re use simply the colunm evolution ?

[mohamed_ahid]

Thx

in max evolution i should have 1 as value and -1 for min evolution .

my simple is not complete but this will be usefull in other expressions not detailled in this sample

[MK_QSL]

Because here you have to freeze the selection by using 1 in set analysis which you haven't frozen in your evolution expression...

[#7]

I would imagine its because the Evoulution is generated as a result of one set of "set analysis" commands (ie { $ }) , then you are trying to refernece it by another set. ( {1} )

I think there are rules around using Calculated expressions.

the solution provided by Manish is the one I would use.

Richard

[MK_QSL]

Have you check my reply?