|
Dear OFT, Thank you very much for wonderful arena application. I imported a survey into Arena prepared in OFC. Some more error is producing and I am trobleshoting them and getting success. But in below case I tried to change the script from OFC to Arena format it is not working.The result shows blank and there is no error in arena. Do my arena script has error? I must be missing something but could not able to figure it out.The result shows same value in excel and collect but not in arena. plese suggest me the correction. Thank you very much. My Formula Excel (EXP(VLOOKUP(DataEntrySheet!D2,value!$B$2:$G$24,2,FALSE)+ VLOOKUP(DataEntrySheet!D2,value!$B$2:$G$24,3,FALSE)LN(DataEntrySheet!F2)+ VLOOKUP(DataEntrySheet!D2,value!$B$2:$G$24,4,FALSE)LN(DataEntrySheet!G2)))/1000 OFC math:pow(2.71828182845905,idm:speciesListData('trees', 'a', species)+idm:speciesListData('trees', 'b', species)math:log(dbh)+idm:speciesListData('trees', 'c', species)math:log(height)) div 1000 Arena Math.pow(2.71828182845905, taxonProp('trees', 'a', species) + taxonProp('trees', 'b', species) * Math.log(dbh) + taxonProp('trees', 'c', species) * Math.log(height)) / 1000 |
|
Dear user, |
|
Dear user, |
|
Dear Rajkumar, |
|
Dear OFT, I already did that. I just wanted to return the value of species extra column but did not get success using like taxonProp('trees','a',species) piece of code. I have to be able to return value from extra column. Then I think I can do what I need right now. Another bad behavior I noticed with the code Math.max(plot.tree.tree_no) + 1 does not produce anything but blank cell. Math.max(tree.tree_no) + 1 produces 3,6,9 or so on. I have attached a video that describes how badly behaves the system. |
|
Dear user, |
|
Dear Team, It is still not working. I have to calculate value using this expression taxonProp('trees','bg',species) . In text field it is shown the formula itself not value, but in numeric field it is blank field. This problem is stopping me further form development. Thanks for your continious support. |
