Add Two Continuous Sums into a Third

While there is no built-in functionality to populate a continuous sum question with previous continuous sum questions we have a script to accomplish this! This can come in handy if you have different totals that you want to add to make one overall total. These steps assume a basic familiarity with Alchemer and Custom Scripting.

Check it out in an example survey! 

OR

Add a survey with this setup to your account. 

Setup

Features and functions used in this script:

• Custom Script Action
• Continuous Sum Question
• Hidden Value Action

Start by building all of your survey questions. In this example survey, we have both continuous sum questions that will be doing the addition on the first page.

On the next page, we have a custom script action with the below script followed by two hidden values. These hidden values will be populated by the script.

You will need to change the IDs for the continuous sum questions and hidden values.

contsum1 = 7 --Question ID for first Continuous Sum
contsum2 = 8 --Question ID for second Continuous Sum
sum1 = 5 -- ID of hidden value for first sum
sum2 = 6 -- ID of hidden value for second sum
next_pageID = 3 --ID of page to jump to so page with script does not show.

array = getvalue(contsum1) 
chars = {'%','$','₠','₡','₢','₣','₤','₥','₦','₧','₨','₩','₪','₫','€','₭','₮','₯','₱','₲','₳','₴','₵','₶','₷','₸','₹'}

finalval=0

for key,value in pairs (array) do

  val = str_replace(chars, '', value) 
  val = tonumber(val)
  finalval = finalval+val

end

setvalue(sum1,finalval)


array2 = getvalue(contsum2) 

finalval2 = 0

for key2,value2 in pairs (array2) do

  val2 = str_replace(chars, '', value2);  
  val2 = tonumber(val2)
  finalval2 = finalval2+val2

end

setvalue(sum2,finalval2)

jumptopage(next_pageID)

Now on the third page, add the third Continuous Sum question where you wish to add all the values together. Populate the Default Value field for each option with the merge code for the Hidden Value sums we populated in the script.  

Now you're ready to test your survey. Is your third continuous sum populating with the totals of the first two creating and total sum? If so, you've succeeded! Congratulations! If not, double check your question IDs.