web

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

News and Announcements icon

Power Platform CommunityForums Power Apps SUM on Group in Gallery

Power Apps

Answered

SUM on Group in Gallery

(1) Share

Report

Report

Posted on by janineb

Good day

I have a gallery that groups 5 "Child" companies under a Parent company (the company group). The formula used is:

GroupBy(varBPGroup,"PARTNER","ZGROUP")

I now have to SUM various totals for each of the "children" companies as per below (for Exposure, Carrying Value, Fair Value etc):

Can you please assist me with the formula for each child company?

Thank you

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @janineb ,

You could try this formula to get the sum value of Exposure, Carrying Value, Fair Value etc.

AddColumns( GroupBy(varBPGroup,"PARTNER","ZGROUP"), "ExposureSUM", Sum(ZGROUP,Exposure), "CarryingSUM", Sum(ZGROUP,'Carrying Value'), "FairSUM", Sum(ZGROUP,'Fair Value') )

Best Regards,

Bof

Join the conversation