Cognito Forms – Calculating Number of Selected Checkboxes in Repeating Section

cognito-forms

I'd like to give a discount based on the number of camp sessions signed up for in a repeating section but can't figure out the formula for doing that. Help?

In the repeating section called "Camper Information" I have a choice box called "sessions":

Sessions

July 1-5 $225

July 7-12 $225

July 14-19 $225

July 21-26 $225

I'm trying to make a calculation that will do:

number of sessions > 1 but < 3 gives a 5% discount

number of sessions > 4 gives a 10% discount

https://www.cognitoforms.com/Edenacres1/SummerOutdoorsSignUpForm

Best Answer

Calculations for Repeating Sections in Cognito Forms, allow you to easily filter and total lists of structured information.

You can find detailed documentation for calculations involving repeating sections here: https://www.cognitoforms.com/support/51/calculations/repeating-sectionstables

For your specific example, the following calculation will automatically calculate the number of selected sessions across all repeating sections:

=CamperInformation.Sum(Sessions.Count)

You can then use this inside a discount calculation for a Price field outside of the repeating section as follows:

=(
   if CamperInformation.Sum(Sessions.Count) > 3 then -0.1 
   else if CamperInformation.Sum(Sessions.Count) > 1 then -0.05 
   else 0
 ) *
 CamperInformation.Sum(Sessions_Amount)

Related Solutions

Cognito-forms – Repeating section in Cognito Forms with variable costs

There are a couple of ways to handle this in Cognito Forms:

Include the camper registration fee of $60 for each camper as part of the repeating section. Then add a Price field for the multi-camper discount below the repeating section, using a calculation like =Campers.Count() > 1 ? (Campers.Count() - 1) * -30 : 0. You can hide this Price field or make it only appear when the discount is not zero. This would produce a receipt like:
```
Camper 1   
    James Philips        $60.00 
Camper 2   
    John Cartin          $60.00 
Camper 3 
    Parker Owens         $60.00
Multi-Camper Discount   ($60.00)
--------------------------------
Subtotal                $120.00
```
You could also charge $30 for each camper and have a separate $30 registration fee that applies to each application. I definitely prefer the first option since it clearly identifies the discount on the receipt.

Long term, it sounds like you would benefit from being able to use the Index of the item in the repeating section within calculations. We are looking at ways to make additional information like this available to calculations. In the mean time, hopefully these suggestions will meet your needs.

Cognito-forms – Calculations and repeating sections

For starters, check out our documentation on calculations, which covers the many ways you can perform calculations with repeating sections in Cognito Forms:

https://www.cognitoforms.com/support/2/calculations

For your specific example, if your repeating section is called Posts and contains a subtotal calculation field for each item called Total, the calculation to sum these up at the bottom of your form would be =Posts.Sum(Total).

Best Answer

Related Solutions

Cognito-forms – Repeating section in Cognito Forms with variable costs

Cognito-forms – Calculations and repeating sections

Related Topic