flex - combobox perfoming different formulas based on user selection -

flex - combobox perfoming different formulas based on user selection -

i have datagrid users set in different numbers 3 different columns. these values calculated after user puts in each value each column. have combobox component within datagrid. want combobox perform different mathematical formula based on user selects. example, in combobox if user selects 'long'(the first alternative in combobox) performs column1*(col2-col3)-col4=total column or if user selects 'short'(the sec alternative in combobox) performs col1*(col3-col2)+column4=total column. how that? i've tried different ideas none have seemed work examples or suggestions appreciated.

public function gettotal(item:object, column:datagridcolumn):string { switch(combobox) { case "long": var sum:int = item.quantity*(item.exit-item.entry)-item.commission; homecoming currencyformatter.format(sum); case "short": sum = item.quantity*(item.entry-item.exit)-item.commission; homecoming currencyformatter.format(sum); } }

i took thought gave me , used parameters function said before maintain running error 1170. saying function not returning value dont understand why? clarification more welcome.

your question bit confusing. how can user "put in different values" "are calculated" users not input calculated values!

that said, sounds need big switch statement calculate values.

switch(combobox.selecteditem) { case ""ong": calculatedvalue = column1*(col2-col3)-col4; break; case "short": calculatedvalue = col1*(col3-col2)+column4; break; }

i assume values displayed in datagrid relate specific object created row. can set calculate function in renderer caluclated column , reference items of object's dataprovider directly:

switch(data['comboboxselecteditem']) { case ""ong": data['calculatedvalue'] = data['column1value']*(data['col2value']-data['col3value'])-data['col4value']; break; case "short": data['calculatedvalue'] = data['col1value']*(data['col3value']-data['col2value'])+data['column4value']; break; }

flex datagrid flex3 combobox