cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JBailey
Frequent Visitor

Sum Formula Working on Windows 10 App, but not on Mobile App

Hi,

 

My app seems to have a couple of bugs which I can't figure out.

 

1). My Currency changes for my data, from £, to $ (Only in Android or iPhone App)

 

2.) I have a Sum formula calculating price totals from a gallery, Names TotalTotalMonthlyCost / TotalTotalUpfront Costs. This works fine for my Win10 App, but not on my Android App.

 

The formula is:

"£" &Sum(Gallery3.AllItems, TotalUpfrontCost)

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JBailey
Frequent Visitor

I have managed to resolve this by removing the "£" &..... from all of my Labels showing prices.

 

Thanks for all your help

View solution in original post

4 REPLIES 4
Sienna
Resident Rockstar
Resident Rockstar

what is the structure of the datasorce linked to your gallery3. You better sum filterred datasource rather then picking them from gallery

JBailey
Frequent Visitor

The Data source for the Service / Upfront Cost / Monthly Cost is a Static import of an excel spreadsheet. This is then filtered into a Collection to be shown in Gallery3

The total itself has been created in the app, not using a data source at all.

Sienna
Resident Rockstar
Resident Rockstar

so try to use

"£" &Sum(YourFilteredCollectionNameHere, TotalUpfrontCost)

 

Or if your collection isn't filtered then filter the collection in Sum function. 

JBailey
Frequent Visitor

I have managed to resolve this by removing the "£" &..... from all of my Labels showing prices.

 

Thanks for all your help

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,385)