News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Sum problem

Power Apps - Building Power Apps

Answered

Sum problem

(0) Share

Report

Report

Posted on by R Bakker

725

Hi all

I have spent so much time on this, I think I am just guessing now.

My intent is to sum Price01 by MinQuantity - CQuantity from Supplier "Safety and Apparel".

So in short, the total cost of an order from that supplier.

All responses Img

All responses (2)

Answers Img

Answers (1)

R Bakker 725 on at

Like (0)

Report

Re: Sum problem

Hi Jesper
Yes this does work, thank you very much.
Verified answer

JesperHuang 56 on at

Like (0)

Report
Re: Sum problem

Hi @Corissandageri ,

I think you are close to the answer, try this one?

"Orders：" & Sum(Filter(Table1, Supplier = "Safety and Apparel", (MinQuantity - CQuantity) > 0), Price01 * (MinQuantity - CQuantity))