cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Help with sum formula for enahnced gallery details

That is odd. I know that there are/were issues with Choice type columns not being filter-able in PowerApps but I thought text fields would work roughly the same. Perhaps they don't. I will do some more checking to see what I can find.

Highlighted
CarlHRVA
Level 8

Re: Help with sum formula for enahnced gallery details

I got it! My final formula looks like this:

 

Text(

Sum(
Filter(
ManagerUIGallery.AllItems,
AGING_x0020_CATEGORY = "Current"
),
'BALANCE AMOUNT'
),

"[$-en-US]$#,###.00"

)

 

Thank you so much for your help! If you edit your original post I'd like to mark yours as the solution 🙂

View solution in original post

Super User
Super User

Re: Help with sum formula for enahnced gallery details

Awesome! Happy that worked out for you! We can mark your post as the solution if you like as you were the one who solved it; I just got the ball rolling.

 

One thing I was going to mention is that you can use the same technique on items in the gallery, such as labels. It's a pretty useful tool to have and I don't see used all that much.

 

Great job on getting that working! 

Super User
Super User

Re: Help with sum formula for enahnced gallery details

I went ahead and marked your post as the solution (one of the perks of being a Super User!). Hit me up if I can try to help with anything in the future!

CarlHRVA
Level 8

Re: Help with sum formula for enahnced gallery details

It would have taken me days to figure that out without your help, thank you so much! This is great and will be a huge benefit to our users. Smiley Very Happy

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (4,615)