HELP
 / 
Deep Dive
 / 
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 individual totals to get a grand total as shown below. The section with Price, Quantity and Total will be copied during submission and you will get the sum of ‘Total’ blanks in the ‘Grand Total’ blank.
This is how you need to use SIGMA in formula block

This is how it will work