I asked a question similar to this a few days ago but without the conditionality.
I was wondering if it is possible to SUM a column of a Collection depending on other values within the Collection?
eg. I would like to be able to SUM all the hours of Team Member1 and Team Member2 seperatly.
Total hours for Team Member1 should be 8.5 and 12.5 for Team Member2.
Any help would be great, thanks.
Go to Solution.
Figured it just after I posted this.
A Filter should be used within the sum.
Sum(Filter(HoursCollection,TeamMember = LoggingName.Selected.Value),Hours)
*LoggingName is the name of the dropdown.
View solution in original post
Keep your eyes open for our upcoming T-shirt design contest!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020