Unanswered

How to sum a gallery column with only non blank values

(0) Share

Report

Posted on by r_voyager

130

I have a gallery in which one column is displayed using text label, when I apply a filter then values change, I want to calculate sum of all values(non blank) from text label after filter.

I tried using :

1.Sum(galOrders.AllItems,
Label37_2.Text)

2.Sum(
Filter(
galOrders.AllItems,
!IsBlank(Label37_2.Text)
),
Value(Label37_2.Text)
)

In the screenshot above, after applying ukg class filter, the total sum should be around 250.

But its returning wrong sum.

Regards,

Categories:

Building Power Apps

All responses (11)

Answers (0)

Sort by

turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

@r_voyager ,
Are you trying to sum the 'total kits' column for all items in the gallery?
r_voyager 130 on at

Like
a
(0)

Report
Copy link

Link copied!

not for all items but only those where values are not zero. Formula has the all items because I don't know how to sum only for some(non zero values) items.
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!
Try this:
Sum(Filter(galOrders.AllItems,Value(Label37_2.Text)>0),Label37_2.Text)
r_voyager 130 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @turnerj3

I tried your code but still no luck , getting wrong sum again.
PowerNuggets 360 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @r_voyager

Check the post below it may help u
https://powerusers.microsoft.com/t5/Building-Power-Apps/formula-do-not-sum-gallery-items-right/td-p/1276220

_____________________________________________________________________________________
Like my answer? - Hit that Thumbs Up. Resolved the Issue? - Hit Accept as Solution.

KR,
r_voyager 130 on at

Like
a
(0)

Report
Copy link

Link copied!

I checked and tried the formulas but it didn't work.

The things is in the text label I extract string from other column. I mean this text label only pick direct values from sharepoint column when one class filter is not applied, but if that filter is applied then it exratct a string from other column i.e total kits and I have formatted it as value.

Don't know why any of the formulas are not working.
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

Does 790 make sense for the whole list or the whole gallery before the filter?
r_voyager 130 on at

Like
a
(0)

Report
Copy link

Link copied!

no it doesn't make sense, after applying the filter if I calculate all values under total kits label in gallery then it should be around 250.
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@r_voyager ,

Try

Sum( galOrders.AllItems, Label37_2 )

Also have the formula there to be zero if no total.
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

@r_voyager ,
Not sure exactly how your gallery items and filters are setup, but something seems to be causing a problem. Technically 0s shouldn’t matter anyway. What happens if you try to sum based on your filter?

Sum(Filter(galOrders.AllItems, Class.value=“UKG”),Label37_2.Text)