web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How can i sum value fr...

Power Apps

Answered

How can i sum value from rows of a collection?

(0) Share

Report

Report

Posted on by HectorOlivos

411

Hello Community!

I have a question and want to know if it´s possible to do this in PowerApps?

I have this collection:

How can I achieve this by creating a new collection?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

madlad 2,637 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @HectorOlivos

You could use something like the following code:

ForAll( Sequence(CountRows(colCumulativePercentages)), Collect(colCumulativePercentagesTotals, { CalculatedVal: Index(colCumulativePercentages, Value).CalculatedVal, Val: Index(colCumulativePercentages, Value).Val, TotalCalculatedVal: Sum(FirstN(colCumulativePercentages, Value), CalculatedVal) } ) )

This should store your desired collection as colCumulatviePercentagesTotals

Hope this helps!

Was this reply helpful? Yes No

Join the conversation