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

asked 30 May '17, 08:55

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

Lauri (OF) ♦♦
6652815
accept rate: 21%


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%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.6k19
accept rate: 20%

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%20%28OF%29's gravatar image

Lauri (OF) ♦♦
6652815
accept rate: 21%

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%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.6k19
accept rate: 20%

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:

×493

question asked: 30 May '17, 08:55

question was seen: 4,314 times

last updated: 01 Jun '17, 11:59