Formula question

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!