Issues related to the summation of previous answers and limitation

User Support Form Building
, , ,
2

Hi,
Welcome to the community forum.

I suggest that you add a constraint script for each question using a logic that allows you to check for every step.

  1. Q2 should have constraint as .<= ${Q1}
  2. Q3 should have constraint as .<= (${Q1}-${Q2})
  3. Q4 should have constraint as .<= (${Q1}-${Q2}-${Q3})

If you are editing in XLS form, then approach below will help you sort this out.

image
image1128×162 7.87 KB

The excel is attached here Test_06182020_2118hrs.xlsx (11.7 KB)

The behavior you will get is this:

image
image707×404 18.7 KB

Checks Q3 as follows
image

Check Q4 as follows
image

Wishing you all the best.

Stephane

1 Like