Math operations with Scoring and Record Value | Experience Community
Skip to main content
Solved

Math operations with Scoring and Record Value

  • April 1, 2021
  • 1 reply
  • 224 views
M
Level 2 ●●
Forum|alt.badge.img+11

Hello everyone,
I am simply trying to multiply the scoring value into the SelectedChoicesRecode but its not working. I used math operations to get the result but result is always 0 which indicate that the scoring values are not calculated in the formula.
I am trying to understand why scoring values for a question is not fetched
$e{q://QID12/SelectedChoicesRecode*gr://SC_3VIHusL0X3b0gM5/Score}

In summary, if I set embedded data to capture the values independently it works but when I try to combine them into a math operation it did not work !!
A-RecordValue = ${q://QID12/SelectedChoicesRecode} (value appears correctly)
A-ScoreValue = ${gr://SC_3VIHusL0X3b0gM5/Score} (value appears correctly)
A-Result = $e{q://QID12/SelectedChoicesRecode*gr://SC_3VIHusL0X3b0gM5/Score} (Did NOT WORK)
Many Thanks in advance...

Best answer by Muqaibil

Hi all,
I solved the issue after many tries to find out the root cause..
simply the issue is the missing Space between the math operator and the variables in the formula. It worked perfectly as expected. Below is an example of the working and invalid scenarios:
Wrong and invalid scenario:
// This below fomula does not contain any spaces before and after
// the multiplication operator (*). That's why it Did NOT WORK..

A-Result = $e{q://QID12/SelectedChoicesRecode*gr://SC_3VIHusL0X3b0gM5/Score} 

Correct and Works well:
// This below fomula contains spaces before and after
// the multiplication operator (*). That's why it WORKs..

A-Result = $e{q://QID12/SelectedChoicesRecode * gr://SC_3VIHusL0X3b0gM5/Score}

1 reply

M
Level 2 ●●
Forum|alt.badge.img+11
  • Muqaibil
  • Author
  • Level 2 ●●
  • Answer
  • April 2, 2021

Hi all,
I solved the issue after many tries to find out the root cause..
simply the issue is the missing Space between the math operator and the variables in the formula. It worked perfectly as expected. Below is an example of the working and invalid scenarios:
Wrong and invalid scenario:
// This below fomula does not contain any spaces before and after
// the multiplication operator (*). That's why it Did NOT WORK..

A-Result = $e{q://QID12/SelectedChoicesRecode*gr://SC_3VIHusL0X3b0gM5/Score} 

Correct and Works well:
// This below fomula contains spaces before and after
// the multiplication operator (*). That's why it WORKs..

A-Result = $e{q://QID12/SelectedChoicesRecode * gr://SC_3VIHusL0X3b0gM5/Score}

Terms & ConditionsAccessibility statement