How do I calculate the total sum of the calculated gross income?
Thank you
Hi Damilare,
Thank you for being part of our community. I am sending you a video: Template designer: Summary field tagging element where you will find instructions on how to calculate the sum for your data. If anything is unclear, please feel free to reach out.
The video I’ve referenced above demonstrates how to aggregate (in this case: summarize) values from one field in the collection of lines, but the Summary field tagging element isn’t limited to this. You can also use it to aggregate values that are result of a calculation on each line.
You want to calculate the value of @SalesPrice * @Qty on each line, and then to summarize these values. Below is a similar example for Purchase order, where you can see that you need to point to the collection of lines in the Value property, and to type the expression @SalesPrice * @Qty in the Aggregate property.
For even more advanced requirement where the similar approach was used please check this forum post.