Multiple choice field

Anyone know how to write the formula in a formula field to total different numbers based on the choices selected by the multiple choice field

the numbers to total are in different number fields

Thank you

- Sakshi_Singh
- 6 yrs ago
- Reported - view
Hi Alain,

Use below formula to sum the choices selected in multiple choice field,

let no := 0;
for i in chosen('Multiple choice') do
no := no + number(i)
end;

Regards,
Sakshi- Ninox Support
- Alain_Bureau
- 6 yrs ago
- Reported - view
Great-Thank You
- Alain_Bureau
- 6 yrs ago
- Reported - view
This does not work. The formula field accepts the formula but the fiend remains blank with no results??
- Sakshi_Singh
- 6 yrs ago
- Reported - view
Hi Alain,

These are two different cases.

The formula to count the number of choices chosen in a multiple choice filed,

count(chosen('Multiple choice'))

Regards, Sakshi- Ninox Support
- Alain_Bureau
- 6 yrs ago
- Reported - view
Ok Great. Thank You, but this is now where in your documentation you keep sending me to. That's why I would like to have a list of all formula you can use with Ninox and some examples on how-Thank You
- hanimax4001
- 5 yrs ago
- Reported - view
let no := 0;
for i in chosen('Multiple choice') do
no := no + number(i)
end;

예제 파일이 없어서 이해할수 없습니다.

예제 파일을 올려주세요

Content aside