---
title: "Blank cell instead of value in arena"
url: "https://openforis.support/questions/3429/blank-cell-instead-of-value-in-arena"
tags: ["arena"]
status: "accepted"
score: 0
answer_count: 7
asked: "2022-08-04T06:00:18"
last_activity: "2022-10-28T11:53:34"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2026. Some rights reserved under creative commons license."
---

# Blank cell instead of value in arena

Asked by Rajkumar on 2022-08-04

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 (score 1, by Stefano (OF) on 2022-08-04)

Link: https://openforis.support/questions/3429/blank-cell-instead-of-value-in-arena/3432

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 (score 1, by Stefano (OF) on 2022-08-04)

Link: https://openforis.support/questions/3429/blank-cell-instead-of-value-in-arena/3430

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 (score 1, by Stefano (OF) on 2022-10-18)

Link: https://openforis.support/questions/3429/blank-cell-instead-of-value-in-arena/3453

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 (score 0, by Rajkumar on 2022-08-04)

Link: https://openforis.support/questions/3429/blank-cell-instead-of-value-in-arena/3431

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 (score 0, by Stefano (OF) on 2022-10-13)

Link: https://openforis.support/questions/3429/blank-cell-instead-of-value-in-arena/3447

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 (score 0, by Rajkumar on 2022-10-14)

Link: https://openforis.support/questions/3429/blank-cell-instead-of-value-in-arena/3449

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 (score 0, by Rajkumar on 2022-10-28)

Link: https://openforis.support/questions/3429/blank-cell-instead-of-value-in-arena/3470

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))