Set Analysis Interval

[#1]

Greetings!

My question is simple, but could not get an answer by referring to the forum, or the Reference Manual. I have a field X with values ​​between 300 and -120. I need to sum the field Y values ​​that are between 1 and 30 of the X and it tried to use Set Analysis, but it still fails:

Sum({<X={'<=30'}, X={'>=1'}>} Y) or

Sum({<X={'<=30','>=1'} Y)

Where I went wrong?

grateful

Stive

Brazil

[Gysbert_Wassenaar]

try sum({<X={">=1<=30"}>} Y)

[sbaldwin]

Hi try someting like:

Sum({<X={'<=30'}>*<X={'>=1'}>} Y)

Thanks

Steve

[#4 · Accepted solution]

Mr. Gysbert,

It was perfect!

Thank You!

Stive

[#5]

sbaldwin,

Its solution is also perfect!

Thanks for the attention!