Set analysis with 'between' operator ?

[dvasseur]

Hello,

I have the following set analysis for Year 2013

sum({<Cust={"=Sum({1<Year={2012}>} Val) <= 20"}>} Val)

But I also have to include another filter for Sum({1<Year={2012}>} Val) >= 15"}>}

So, something like this:

sum({<Cust={"=Sum({1<Year={2012}>} Val) between 15 and 20"}>} Val)

which is of course not working

I could use 2 expressions but is there a better and nicer way in only one expression ?

Regards,

David

[gandalfgray]

Hi

Try

sum({<Cust={"=Sum({1<Year={2012}>} Val) >=15 <=20"}>} Val)

//GG

[dvasseur]

Hi Gandalf,

I already tried this, it's not working

Thx anyway !

David

[sreenivas]

sum({<Year={2012},Val={">=15<=20"}>}Val)

[#5 · Accepted solution]

Hi ,

sum( {$<Cust = {"=Sum({1<Year = {2012}>} Val ) >= 15 and Sum({1<Year = {2012}>} Val ) <= 20"}>} Val )

Please check the Attached App..

Hope it helps you..

[dvasseur]

Hi bhaskar,

I thought I tried that but I should have missed something because, indeed, it's working, thanks !

David

[francoiscave]

Hi Dave,

Another solution :

sum({<Cust={"=Sum({1<Year={2012}>} Val) <= 20"}> * <Cust={"=Sum({1<Year={2012}>} Val) > 15"} > } Val)

Best regards,

François