Table type entity: how to check sum of attributes in a column?

Question

Hi Team,

We have in the Collect survey an entity [multiple, table layout] with 3 numeric type attributes, with 1-4 entries (rows). We need to check that sum of each column is 100. What is the best way to do this verification in Collect?

Thanks, Lauri

Answer 1 · 2017-05-30T11:04:29

Hi Lauri,
What you can do is to create 3 calculated attributes outside of the entity and define for each of them an expression like this:
sum(ENTITY_NAME/ATTRIBUTE_NAME)
so that the user can keep track of the current sum of each column. Also these calculated attributes can be used to define some validation rules that use the sum.
Thanks,
Open Foris Team

Answer 2 · 2017-05-31T07:57:58

Hi Stefano,

otherwise fine, but validation does not work because there seems to be this limitation for a calculated attribute: survey.validation.attribute.cannot_specify_checks_for_calculated_attribute

Regards, Lauri

Answer 3 · 2017-06-01T11:59:32

Hi Lauri,
Of course the validation of the calculated attribute does not work because it cannot be applied... Instead I was talking about the validation of some other attributes where you can use the newly created calculated attributes.
Thanks,
Open Foris Team

Table type entity: how to check sum of attributes in a column?

3 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