web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Sum problem

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

JesperHuang 56 on at

Like
a
(0)

Report
Copy link

Link copied!
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))

Was this reply helpful? Yes No
R Bakker 725 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation