Hello @jadmac12
Assuming you have three number fields, fieldname1, fieldname2, and fieldname3 for Small, Medium, and Large, respectively. And a checkbox field (fieldname4) with only one choice with the text “Do you want an extra feature?” and value 3.
Finally, insert a calculated field in the form with the equation:
fieldname1+fieldname2*1.5+fieldname3*2+fieldname4
And that’s all.
Best regards.
Hi @codepeople
The above doesn’t seem to work for me, please see: shorturl.at/ixMT8
It results in a score of 21 and 27 as detailed above.
Any help would be appreciated.
Thank you
Hello @jadmac12
There is a difference between the initial description and the use case.
The initial description was:
small – value of 1
Medium – value of 1.5
Large – value of 2
Do you want the extra feature – value of 3 if selected and 0 if not
The equation that represents the description above is:
fieldname1+fieldname2*1.5+fieldname3*2+fieldname4
However, the use case you described was:
Therefore, if someone selections 3 small and 10 medium, the equation is 3 x 3 + 10 x 1.5 = 24 and then if they add the extra feature, it would be 27.
In the use case, the factor corresponding to small is 3 and not 1 as in the description above. If 3 is the correct factor for small, the equation would be:
fieldname1*3+fieldname2*1.5+fieldname3*2+fieldname4
Best regards.
@codepeople perfect, thank you!
