Doing Sum while you copy the section during Submission
Doing Sum while you copy the section during Submission
If you use the option to copy a section while submission and want to get a total of some fields of the copied section, use the SIGMA formula in formula block.
Write SIGMA(unique field name of the field to be summed) in the formula block.
For example, suppose we need to sum the line item totals to get a sub total as shown below. The section with Price Per Unit, No. of Users and Line Item Total will be copied during submission and you will get the sum of ‘Total’ Line items in the ‘Sub Total’ blank.
FAQs
Try our free plan
It will answer many more questions within just 15 minutes.