Blank cell instead of value in arena

Question

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

Accepted Answer · 2022-08-04T17:40:12

Dear user,
Thanks for reporting these issues, we are working already to a new version of Arena that will be released soon, we will let you know when it will be ready.
Thanks again,
Open Foris Team

Answer 2 · 2022-08-04T13:01:19

Dear user,
Please try to split the expression into several "read only" attributes and check if all the parts of the expression are working as expected.
Many thanks,
Open Foris Team

Answer 3 · 2022-10-18T09:04:18

1

Accepted answer

Dear Rajkumar,
The problem has been fixed with the latest version of Arena (1.2.1).
Please check that it works in your survey.
Many thanks,
Open Foris Team

Answer 4 · 2022-08-04T15:57:19

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.

https://youtu.be/QASaUASI6b0

Answer 5 · 2022-10-13T11:27:41

Dear user,
A new version of Arena has been released with a bunch of updates related to the evaluation of expressions.
Please let us know if your expressions are working as expected.
Many thanks,
Open Foris Team

Answer 6 · 2022-10-14T16:42:03

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.

Answer 7 · 2022-10-28T05:55:12

0

Accepted answer

Dear OFC, Thank you very much for updating Arena. I did some trick to produce my result. taxonProp is still not working with messing other expression. But it is working creating extra node for extra property. Now it is working. My serious concern about arena will be describing the issue in new question. Thank you.

Dear Rajkumar, can you give us some more details? Is the function taxonProp working or not in your case? If you want we can contact you to your private email address to better understand your issue. Many thanks.

Stefano (OF) ♦♦ 28 Oct '22, 11:53

Blank cell instead of value in arena

7 Answers

Your answer

Insert a link

Insert an image

Follow this question

By Email

By RSS

Open Foris

Question tags

Related questions

Keyboard shortcuts

Anywhere

Lists of questions

Question pages