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 15 hours ago

Hanif's gravatar image

Hanif
1313
accept rate: 0%


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 11 hours ago

Lauri%20%28OF%29's gravatar image

Lauri (OF) ♦♦
86521016
accept rate: 20%

edited 10 hours ago

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

(8 hours ago) Hanif Hanif's gravatar image

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

Regards, Lauri

(8 hours ago) Lauri (OF) ♦♦ Lauri%20%28OF%29's gravatar image
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:

×113

question asked: 15 hours ago

question was seen: 28 times

last updated: 8 hours ago