0

How to add up the number of ticks in dynamic options

4 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr agoThu, February 23, 2023 at 6:45 AM UTC
    • Reported - view

    count(numbers('Multiple choice (dynamic)'))

      • cyan_silver
      • 1 yr agoThu, February 23, 2023 at 8:42 AM UTC
      • Reported - view

      RoSoft_Steven  thank you

      The current answer is 6, how can I modify it to get the respective answers, thank you。

    • Ninox partner
    • RoSoft_Steven.1
    • 1 yr agoThu, February 23, 2023 at 1:02 PM UTC
    • Reported - view

    Not an easy one but this works:

    let c := text('Choice (dynamic)');
    let s := numbers('Multiple choice (dynamic)');
    let sa := (select '02')['01'.ABC = c];
    let ss := s[var v := this;
            not sa[= v]];
    count(s[var v := this;
            not ss[= v]])
    

    張良仲

      • cyan_silver
      • 1 yr agoFri, February 24, 2023 at 12:30 AM UTC
      • Reported - view

      RoSoft_Steven  thank you very much,it's really useful.