Using a List Box Selection is an Expression

[#1]

I am trying to have a list box select (percent probability to close) and would like to have the below formula reference a selected range rather than it being hard coded.

sum({ $<Forecast_CloseDate={'05-2011'}, Forecast_Probability ={'>70<100'}>} ForecastOppAmount)

Any and all ideas would be helpful

Thanx

[Anonymous]

Use 2 variables with Input Boxes.

Create new object > Input Box

Click new variable and name the variable ie. vRangeStart

Click new variable again and name it  ie vRangeEnd

(Use label box to 'rename' the variable in the UI.

Users can then enter values free form.

Refer to variables in expression using set analysis.

Something like

sum({ $<Forecast_CloseDate={'05-2011'}, Forecast_Probability ={'>=$(vRangeStart)<=$(vRangeEnd)'}>} ForecastOppAmount)