Is it possible to use a select in field action on a field calculated in a listbox?

[#1]

Hi there,

I am creating a listbox out of a calculation, and I want to create an action to select some of the values in the listbox. Does anyone know if this is possible?

Thanks,

James

[swuehl]

I believe it is not possible to directly select those values. But maybe in an indirect way. Could you give an example of  your list box field expression?

[CELAMBARASAN]

Hi,

     It is possible if you apply the selection to the fields that involved in calculation.

     For example you create a list box by combining month and year field then you need to select the value in field month as well as in year in the action then automatically it selects the value in the list box.

Hope it helps

Celambarasan

[#4]

Thank you both for getting back to me. The list box is created only from an expression. The expression is horrible, but the set of data is small, and it works...

if(if(min(aggr(sum(aggr ([Historical Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)),Item))=0 ,0,floor(sum(aggr ([2011 Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)),0.001)-sum(aggr ([Historical Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)))>= 0 AND round(avg(aggr([2011 Average Score],Item)),.01)-round(avg(aggr([Overall.2011 Average Score],Item)),.01)>=0,'Green',if(if(min(aggr(sum(aggr ([Historical Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)),Item))=0 ,0,floor(sum(aggr ([2011 Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)),0.001)-sum(aggr ([Historical Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)))<= 0 AND round(avg(aggr([2011 Average Score],Item)),.01)-round(avg(aggr([Overall.2011 Average Score],Item)),.01)<=0,'Red',if(if(min(aggr(sum(aggr ([Historical Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)),Item))=0 ,0,floor(sum(aggr ([2011 Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)),0.001)-sum(aggr ([Historical Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)))< 0 AND round(avg(aggr([2011 Average Score],Item)),.01)-round(avg(aggr([Overall.2011 Average Score],Item)),.01)>0,'Yellow',if(if(min(aggr(sum(aggr ([Historical Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)),Item))=0 ,0,floor(sum(aggr ([2011 Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)),0.001)-sum(aggr ([Historical Percent Favorable],Item)* aggr([Valid Returns],Item))/sum(aggr([Valid Returns],Item)))> 0 AND round(avg(aggr([2011 Average Score],Item)),.01)-round(avg(aggr([Overall.2011 Average Score],Item)),.01)<0,'Yellow',
'White'))),$(=getcurrentfield(Group))

The result is a list box that contains the values green, red, yellow and white.

I would like to be able to use a button that selects one of these derived values.

Thanks again for your help

James