1

I have two input fields with type number A and B. I added A calculation field where I want to show the average of these two input fields. So I typed in =(A + B)/2.

I get an error on this formula saying:

Error at character 0. Type must be decimal.

But I cannot choose for decimal field type in the radio list.

Does anyone have a solution for this?

1 Answer 1

0

In cases where the input type cannot be clearly defined but the input is to be treated as a number you can actually force the calculation to evaluate the input as a number.

So in your scenario where you have 2 radio list choices and you want to average the numbers.

Instead of this:

=(A + B)/2

Try this instead:

=(int32.Parse(A)+int32.Parse(B))/2

I did a similar test. Here is the form on the form builder screen with calculated field:

Form Definition

Here is the form itself doing the calculation:

Form with Calculations based on radio boxes

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.