I am trying to get a summary of inputs based on 3 different questions. Using Repeat.
My questions are:
Area in sqft, Distress Type, Rating
Possible Distress types
Alligator Cracking, Bleeding, and Clock Cracking
Possible Ratings
Low, Med, High
Area is inputted
I hope to have an output of something like this:
Rating | Area of Alligator Cracking |
Low | 20 |
Med | 100 |
High | 60 |
Total | 180 |
Rating | Area of Bleeding |
Low | 5 |
Med | 6 |
High | 7 |
Total | 18 |
I am looking for a way to have the area increase after each repeat.
Thanks
Hi Rickey,
One way to this is, in the repeat, have a set of calculate questions for each of the category/value combinations you wish to create a sum for. Each of these would have a formula using an if() function to check if the correct category was selected, and then put the value in if true and 0 if false. For example, the 'Low, Alligator' category (lets call this low_allig) would look something
if(selected(${Severity}, 'low') and selected(${distress_type}, 'alligator'), ${sq_ft}, 0)
You then would have a question that uses the sum() function to add the values in the parent part of the form:
sum(${low_allig})