Help with syntax for a mathematical operation with piped text? | XM Community
Skip to main content
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.
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.
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!

Leave a Reply