techgal327

Hi, I hate to be a nag but I need some help. I’m not a developer or very good at coding so please bear with me.

Let me give you some background to see if you can provide a better suggestion. For this quiz, we have 7 sections with 7 questions. I need to take the average of all the questions in one section (which are primarily radio buttons that are weighted) and then calculate the average for all of the sections and that’s how we come up with the CRM strategy score.

However, there are certain sections that may not pertain to a particular business owner, so they may select No. I want that section to be excluded in the calculation of the averages of ALL of the sections. Right now, even with the formula above, it seems as if the 0 is still weighted in and the scores are very low. If I choose not to answer two sections, but mark everything else with Strongly Agree or Agree, I keep receiving a score of .16 instead of the .8 range.

Part two, I created the dependencies for the calculated field form for the overall crm strategy score. I used hidden fields and put the text in the values. I then created the dependency to show up based on the value. But when I tried this, no values showed up at all.

Here is a screenshot of how I have the dependencies created for the overall crm strategy calculated field: http://www.awesomescreenshot.com/image/2409575/16f0e50bcfb1c6969c28957e0ab616b2

Here is a screenshot of the formula for this specific field: http://www.awesomescreenshot.com/image/2409580/ef8322b637dc68a12c48f136690a77fe

I appreciate any and all help as I want the client to be happy with this form. Thanks.

Hi, I don’t think the formula is working exactly that way. For the value of each field, the lowest number is .5 (strongly agree weighs at .9 and strongly disagree is .5). When I performed a test, I left off the fields for two sections and got an answer of .16 or 16%. It seems as if the calculations are including the 0’s from the two sections.
Here is the formula that I am using based on your response:
(function(){
var n = 0, total = 0, fields = [fieldname1,fieldname34,fieldname45,fieldname56,fieldname67,fieldname78];

for(var i in fields )
if(fields[i]){total += fields[i]*1; n++;}

return PREC((total/7,2)*.08);
})()

Also, I like the idea of setting up dependencies based on the range they are in, however, I’m not sure how to do that for a thank you page. It’s clear how to create this within the form.

One last question, I want to set up a field called “account number” which will be hidden from the user, however, i want it to automatically create a unique number each time. Is this possible with this form? Thanks for your support.