Make a query with a certain value range

[Anonymous]

Good day.

I have the following expression sum ([Q1 CAT]) which gives me some data in percentages from 0% to 100%. I want to know if there is a function on this expression that brings me those results but in a certain range That is, that is above 80%, less than 50% or between 50% and 80%.

I appreciate the collaboration.

[petter · Accepted solution]

You could do something like this:

If(Sum([Q1 CAT])>0.8,Sum([Q1 CAT]))

If(Sum([Q1 CAT])<0.5,Sum([Q1 CAT]))

If(Sum([Q1 CAT])>=0.5 AND Sum([Q1_CAT])<=0.8,Sum([Q1 CAT]))

[Anonymous]

Thanks Petter, that's exactly what i needed