How to branch based on a formula? | Experience Community
Skip to main content
Question

How to branch based on a formula?

  • June 15, 2026
  • 1 reply
  • 4 views
L

I am trying to branch based on a formula, but can’t seem to get it working no matter what I try.

Specifically, I am using the the Motion Sickness Susceptibility Questionnaire. (https://www.westminster.ac.uk/sites/default/public-files/general-documents/MSSQ-short-form.pdf)

Essentially, there are two identical matrix table, 9 rows, 5 columns. The columns are scored [blank, 0,1,2,3].
For each table, I need  (sum of score of each table x 9) / (number of non-blank rows).
I sum both tables together, which is then used to branch.

 

    1 reply

    C
    Level 5 ●●●●●
    Forum|alt.badge.img+28

    Perhaps you can consider using scoring.

    1) set the score 0,1,2,3 for the column under a scoringcategory for both tables.

    2) set blanks to be -1 for the blank column under blankrows for both tables.

    Then, using math operation for embedded data totalscore = scoringcategory * 9 / (9 * 2 + blankrows)

    Terms & ConditionsAccessibility statement