Skip to main content
Nintex Community Menu Bar

How do I count items in repeating section and get the total in Nintex WFC

  • September 1, 2022
  • 2 replies
  • 464 views
J
Forum|alt.badge.img+2

Hi there all, 

 

I know I am close... but not getting it... I want to count the items in the repeating section, I am able to get the count per repeating section but I want the total... from the total I am creating a rule so they can't click more than 5.

I am able to count how many total rows and the section, and I can count how many Sold Option are in each section. But I want to total them. 

I tried sum(countCurrItems)

countCurrItems = count (current section.sold Option) 

Any suggestions would be great. 

25957i2D0B340F702C1896.jpg

    2 replies

    Garrett
    Forum|alt.badge.img+16
    • Garrett
    • Scout
    • September 1, 2022

    Hi @jbolanoswga 

     

    1. Place a Number control into the Repeating Section.

    Add a rule for the Number control.

    The formula for counting is 

    This count the number of selection ticked in the Current Row for the Multiple-Choice-Type

     

    Next, we add a Number control at the end of the Form (Outside the Repeating Section) 

    This will have the Sum of each Row.

    Add a rule for the Number control.

    The formula for the Sum is

     

    The Final Screen

    The Row field is the Count of Choice selections

    The FINAL field is the Sum of all the Row fields

     

    Cheers

    J
    Forum|alt.badge.img+2
    • jbolanoswga
    • Author
    • Rookie
    • September 3, 2022

    Hey there ...@Garrett

    The rules through me for a loop. I am adding these for clarity in case others need it.

    Quotes is my repeating section.

     

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement