Unanswered

Show results > 0 after combining Sum and Filter

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone,

I am struggling where to insert the 'Show Results > 0' after the Sum and Filter.

Situtation: I have a column in Dataverse named 'Amount' with transactions like +40, - 40. In PowerApps I have inserted this formula to calculate the current amount in stock for a product and this works perfectly. Now it returns also the 0 values, which I want to Filter out of my Gallery.

Sum(
Filter(
'Stock Transactions',
Stock.'Stock Id' = ThisItem.'Stock Id'
),
Amount
)

Desired outcome: Filter out the values that are 0 or show results > 0. I have tried to insert Amount = 0, but it does not seem to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (0)

Report

Filter(
'Stock Transactions',
Stock.'Stock Id' = ThisItem.'Stock Id' && Amount >=0
)

You do not need Sum if you are just trying to get anything which is greater than or equal to 0.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I think I misformulated it. My gallery now shows for example: Heineken with an Amount of 0. The amount is calculated from my Dataverse with Stock Transactions + 10, -10, +5, -5 equaling 0. To be able to calculate this I need the Sum Function. In short, if the result of the sum function = 0 I do not want to show it in the gallery.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

This is the formula to Filter the Gallery.

Sort(
Search(
AddColumns(
Filter(
Stock,
'Stock (Views)'.'Active Stock'
),
"IssueDate",
DateValue('Issue Date')
),
txtStockListSearch.Text,
"my product name"
),
IssueDate,
Ascending
)

Was this reply helpful? Yes No