Select to view content in your preferred language

sumif function for repeats

585
2
03-23-2023 05:38 PM
Status: Open
Labels (1)
bhartzell
Emerging Contributor

I would like to be able to sum an integer field in a repeat by the values of another attribute.  My workflow is to store information about the amount/length of pipe that has been installed on a daily log record.  There could be sanitary, storm sewer, or water main pipes all stored in the repeat, each with a number of lineal feet. I would like to display a total at the end of the form that tallies the amount of lineal feet installed for that day by type of pipe.  The sum function currently sums over all repeat records. 

2 Comments
Justin_P

This would be great!

KatarzynaDąbrowska-Stanik

Yes! This would be very useful!