Help with syntax for a mathematical operation with piped text?

Question

Hello all,

I am attempting to use the following line of syntax:

$e{ ( abs(118 - q://QID72/ChoiceTextEntryValue ) + abs(35 - q://QID84/ChoiceTextEntryValue ) + abs(76 - q://QID88/ChoiceTextEntryValue ) + abs(37 - q://QID92/ChoiceTextEntryValue ) + abs(112 - q://QID96/ChoiceTextEntryValue ) + abs(56 - q://QID100/ChoiceTextEntryValue ) ) / 6 }

The syntax is supposed to calculate the absolute value for 6 responses subtracted from a preset number, sum these 6 responses, and divide by 6 to provide the mean. The equations to calculate the absolute values are working correctly when tested in isolation, so the issue appears to be related to the fact that I have multiple levels of parentheses. Instead of dividing by 6 at the end, I could also try a mean function if one exists.

LaurenK · Accepted Answer

Hey @AnthonyM! If you have not yet already, I would recommend checking out this page about troubleshooting math operations. Otherwise, feel free to reach out to our Support Team directly, so they can further troubleshoot this with you!

PeeyushBansal · Answer

Parentheses in above calculation seems correct. If it is creating problem . In first embedded variable calculate sum of your absutes and create other final embedded variable where you decide earlier embedded variable by 6.There is no direct mean function available.

Sign up

Login to the Community