Skip to main content

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

  • 1 September 2022
  • 2 replies
  • 284 views

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

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


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.







 


Reply