In order to sum the value of some columns and divide by the number of data added. But the value is not being made.

I have used the following application formula.

CEILING(MOD(SUM(LIST(LEN([Col1]),LEN([Col2]))), 2))

What can I do?

In order to sum the value of some columns and divide by the number of data added. But the value is not being made.

I have used the following application formula.

CEILING(MOD(SUM(LIST(LEN([Col1]),LEN([Col2]))), 2))

What can I do?

Can you clarify what you are trying to do? If you want to sum the value of columns, then why you have used LEN() function? What is the type of those columns?!

the values of columns are populated by the user through options from 1 to 5. As their type are Enum, I figured that it had been necessary to change from number using the function Len (). I Also

tried this with a Number () function, but it did not work either.

My necessity is simple and simple:

sum the aswers of user and divide the number of responses: make an average. I even tried to do an Average () function and

I did not succeed

What can I do?

If you have Enum column that its values are 1, 2, 3, … you could set Base type to Number (screenshot below), then that column could be used in a math expression.