I'm quite new to powerapps and the tech world in general, and I'm experiencing a rather confusing problem.
My data source is an excel sheet on Google Drive - with 144 rows of data. In design mode I have used the formula Sum(TYSales,Sales) which gives me a large total, about 1,000,000. When I view the app on my mobile the total reflecting is about 80,000 (I can see it is the sum of only a few specific rows).
I don't quite understand why my mobile app has a different value to what I see on my PC (in the design)? I also cannot determine why it has only selected specific rows to add up on the phone app.