Incorrect Score Summation in Arena After Importing Collect Survey

  • Asked
  • Active
  • Viewed 762 times
0

Dear OpenForis Support Team,

I have successfully imported a .collect file containing a performance scorecard into Arena. The survey was published successfully, and all logical connections appear to be functioning correctly.

However, I am experiencing an issue with the score calculation. The scorecard consists of eight scored attributes. As a test, I selected response values that should produce a total score of 23. However, Arena displays the calculated sum as 24420524 instead of 23.

Interestingly, the same calculation works correctly in .Collect interface.

Could you please advise why this is happening and how it can be resolved?

For your information, the scores were developed using Category (Code List) attributes, where the response codes themselves represent the score values (e.g., 0, 2, 4, and 5). It appears that Arena may be concatenating the selected codes rather than treating them as numeric values for summation.

I would appreciate any guidance on the correct approach for calculating totals from category-code responses in Arena.

Thank you for your assistance, and I look forward to your support.

Kind regards,

Hanif

asked

Hanif 13●1●3 accept rate: 0%

1

Accepted answer

Dear Hanif,

category attribute's code is always a text, and if you sum up these using the plus sign then you concatenate the codes. The correct approach is to convert codes to numeric first, as follows:

Number(code_attr1) + Number(code_attr2) + .. + Number(code_attr8)

Regards, Lauri (OF Arena Team)

permanent link

answered

Lauri (OF) ♦♦ 865●2●11●16 accept rate: 20%

edited

Dear Lauri,

Thank you for your prompt response and clarification.

I have tried to apply the formula using the Number() function, but unfortunately I was not able to make it work successfully in Arena.

Could you please provide an alternative guideline or a simple example showing how to correctly implement this calculation within Arena? If there are any specific syntax requirements, calculation node settings, or examples using category attributes, that would be very helpful.

Thank you for your support and guidance.

Kind regards,

Hanif

Hanif Hanif

You need to convert every attribute separately using the Number() function, not the whole expression once.

Regards, Lauri

Lauri (OF) Lauri (OF) ♦♦

Your answer

Insert an image

Say what the image shows, for people who can't see it.
At least 50 characters

Powered by the Open Foris edition of OSQA Content licensed under CC BY-SA 3.0

This Q&A software is free and open source (GPL). Any organisation can run it for its own community: get the code and instructions at github.com/openforis/osqa.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.