0

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

6 replies

null
    • 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??

    Screen Shot 2018-04-12 at 9.52.34 AM

    • 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'))

    Screen Shot 2018-04-12 at 17.11.19

    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
    • 6 yrs ago
    • Reported - view

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

     

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

    예제 파일을 올려주세요

Content aside

  • 6 yrs agoLast active
  • 6Replies
  • 3795Views