0

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

null
    • Mel_Charles
    • 3 yrs ago
    • Reported - view

    add a formula field

    and insert ......     count(chosen('your choice field name here')) as the formula

    see example

    Screenshot 2021-03-29 at 19.15.35

    formula in this example is count(chosen(ChoiceList))

    point it to wherever your dynamic list is

    • Fred
    • 3 yrs ago
    • Reported - view

    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.

    • Fred
    • 3 yrs ago
    • Reported - view

    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.

    Screen Shot 2021-03-29 at 11.53.23 AM

    • Fred
    • 3 yrs ago
    • Reported - view

    Update, chosen does not work with Multiple Dynamic Choice fields.

    • Sean
    • 3 yrs ago
    • Reported - view

    You can use count(numbers(MCD)). The language reference has been updated and it now includes the numbers() function.

    • Fred
    • 3 yrs ago
    • Reported - view

    Thanks for the update, Sean.

    • Richard_Bramall
    • 3 yrs ago
    • Reported - view

    Perfect that has done the trick Sean! Thankyou all glad I wasnt the only one struggling

Content aside

  • 3 yrs agoLast active
  • 7Replies
  • 570Views