How to multiply one score times another score

​@AmazingAging - you should probably use at least one variable. 

the simple example quiz at this link uses a single variable called v_total to hold the results. 

this is simple but gives you an idea of how it can work. 

des

Thanks so much for your help! I have 40 variables total. But for the sake of discussion, let’s say that I have 3 variables. A, B, and C. My overall goal is an assessment score. For scoring I need to multiply Variable A times Variable B. The product, let’s call it Variable D, is then added to Variable C to tally the final score. Do you know if that is possible? Otherwise, I have to export it into a Google sheet and calculate it there. Does that make sense?

​@AmazingAging - extend my example with another variable called v_final and use logic rule to add Variable D (v_total from my example) to v_final and then add variable C to v_final to get the sum. 

i usually do it like that to preserve the ‘subtotal’ variables as they are … 

des

Thanks John! I see you adding. Is it possible to multiply variables? That’s what I’m trying to do.

​@AmazingAging - yup

i created another variable called v_price to represent price per unit in the example

and here is the second statement page with v x v rule

des

Wow! Thank you! That may be the trick. I’ll try it and let you know. Happy 4th!

I finally had some time to look at this and I can’t figure out how to do it. Let me explain my scoring. Perhaps you can tell me if it’s even possible. 

Besides contact information, I have 4 group variables and 6 single variables. All answers are numeric values. Each of the 4 group variables have 5 single variables within them. So there is a total of 26 scores.  

The final outcome is two scores that are evaluated together. But the underlying group variables are also something we want to keep.

The Group Variables are called pr1-pr5, na1-na5, mp1-mp5, cg1-cg5. I’d like scores for each individual group. We can call them pr_total, na_total, mp_total, cg_total. 

The other 6 variables are single variables. In 5 of them the user selects all that apply. So I want to sum them as well.  They are hidden_risk, time_dysfunction, quality_impact, human_capital, intrinsic_value, systemic_value. 

The final formula is: 

process_relational    = pr1 + pr2 + pr3 + pr4 + pr5    (-10 to +10)

narrative_awareness   = na1 + na2 + na3 + na4 + na5    (-10 to +10)

meaning_purpose       = mp1 + mp2 + mp3 + mp4 + mp5    (-10 to +10)

collaboration_growth  = cg1 + cg2 + cg3 + cg4 + cg5    (-10 to +10)

``

cultural_health = process_relational + narrative_awareness + meaning_purpose + collaboration_growth 

hidden_risk = time_dysfunction + quality_impact + human_capital + intrinsic_value + systemic_value 

total_risk = hidden_risk * turnover_level