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

asked 04 Aug, 06:00

Rajkumar's gravatar image

Rajkumar
17411949
accept rate: 4%

edited 04 Aug, 06:03


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

permanent link

answered 04 Aug, 17:40

OF%20Collect's gravatar image

OF Collect ♦♦
3.9k18
accept rate: 22%

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

permanent link

answered 04 Aug, 13:01

OF%20Collect's gravatar image

OF Collect ♦♦
3.9k18
accept rate: 22%

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

permanent link

answered 04 Aug, 15:57

Rajkumar's gravatar image

Rajkumar
17411949
accept rate: 4%

edited 04 Aug, 18:02

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×451

question asked: 04 Aug, 06:00

question was seen: 116 times

last updated: 04 Aug, 18:02