How to sum the column of a nested horizontal gallery

(0) Share

Report

Posted on by jzy5282

How can I add a total row in the form that sums the nested gallery items?

Parent Gallery:

Filter(
ShowColumns([@LineHeaders],
"ID",
"Title",
"FK_Cmit_Lhdr",
"AccountDecrease",
"AccountIncrease",
"Remark",
"TransactionTerm",
"TransactionType",
"LineStatus",
"fyValues"
 ),
FK_Cmit_Lhdr.Value=varComit.Title)

Child Gallery Items:

With({val:
 Split(ThisItem.fyValues,"|")},

 ForAll(Sequence(CountRows(val)/4, 1, 4),
 {fyAmt:Value(Last(FirstN(val, Value)).Result),
 fyKeyi:Last(FirstN(val, Value+1)).Result,
 fyStat:Last(FirstN(val, Value+2)).Result,
 fyPk:Last(FirstN(val, Value+3)).Result}
 ) 
)

The Year headers are in a separate gallery with Items: Sequence(varComit.NumberofYears, varComit.FYStart,1)

expanded to show FY on the child gallery:

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jzy5282,

Do you want to sum the total number within a Label outside the Gallery?

If you want to sum the whole column value, you just need to add a Label outside the Gallery, and set the text property as below:

Sum(ChildGallery.AllItems,Label_In_ChildGallery.Text)

Was this reply helpful? Yes No
faruk1 110 on at

Like
a
(0)

Report
Copy link

Link copied!

I Tried but not working , can you give me better solution

Was this reply helpful? Yes No