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

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

collect

asked 30 May '17, 08:55

Lauri (OF) ♦♦
765●2●8●16
accept rate: 20%

3 Answers:

active answers oldest answers newest answers popular answers

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

permanent link

answered 30 May '17, 11:04

Stefano (OF) ♦♦
4.9k●1●1●9
accept rate: 19%

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

permanent link

answered 31 May '17, 07:57

Lauri (OF) ♦♦
765●2●8●16
accept rate: 20%

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

permanent link

answered 01 Jun '17, 11:59

Stefano (OF) ♦♦
4.9k●1●1●9
accept rate: 19%

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

learn more about Markdown

Question tags:

collect ×494

question asked: 30 May '17, 08:55

question was seen: 4,774 times

last updated: 01 Jun '17, 11:59

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

Follow this question

Related questions