Sum Columns in Related Child Tables

(2) Share

Report

Posted on by BenDonahue

932

I have a master table the records events (Events). There is a child table that records %Complete for each task on a 1-M basis (Tasks).

Each Event defines a dataset in the child table containing all the Tasks associated with that Event.

I want to get a sum of all %Complete from the Child table for each Event.

This works:

Sum(First(Events).Tasks, %Complete)

This does not work:

Clear(TotalPctComplete);

ClearCollect(Events, Columna = "this"); 
// I added the above to demonstrate that simply taking a Sum against the whole Task set on PercentComplete will not satisfy my requirements)

ForAll(colEvents As _Table,
 Collect(TotalPctComplete,
 {
 TotalPercent: Sum(_Table.Tasks, PercentComplete)
 }
);

Any assistance is greatly appreciated, so, thank you very much, 😁!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

KeithAtherton 3,705 Most Valuable Professional on at

Like (0)

Report

Hi @BenDonahue,

Bit of a leftfield suggestion here but have you considered creating a rollup column on the parent Event table?:

https://learn.microsoft.com/en-us/training/modules/create-define-calculation-rollup-fields/1-intro

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Connect with me online.

Was this reply helpful? Yes No