Sum the checked / ticked Dynamic Multiple Choice
Hi,
I have a list of Multiple Choice Dynamic Radio Buttons, I am trying to sum or count the amount of 'checked' items.
For example, using the dynamic list as a checklist, then requiring a formula which says 7/10 checks complete, or 70% complete
7 replies
-
add a formula field
and insert ...... count(chosen('your choice field name here')) as the formula
see example
formula in this example is count(chosen(ChoiceList))
point it to wherever your dynamic list is
-
I asked that question to Nixous and they said it should and will bring it up to Ninox. I'm not sure when or if I'll hear back.
-
Hi Mel -
Give it a try with a Multiple Dynamic Choice field. If you do a count you only get 1. As you can see in my example, Riders is a multiple dynamic choice field. You can see three riders selected. But the Count of Riders field which is just count(Riders) shows up as 1. The Riders Selected field is another formula field that points to Riders jus to show that you can see the three selected riders.
-
Update, chosen does not work with Multiple Dynamic Choice fields.
-
You can use
count(numbers(MCD))
. The language reference has been updated and it now includes thenumbers()
function. -
Thanks for the update, Sean.
-
Perfect that has done the trick Sean! Thankyou all glad I wasnt the only one struggling
Content aside
- 3 yrs agoLast active
- 7Replies
- 587Views