Hello Appsheet community,
I am creating an app in which users can earn points for recycling. At the moment I am trying to create a scoreboard in my app, which is a view that displays each user’s points and sorts them from least to greatest. I have a “Total Recycling Points” Column in my Profile table that refers to the “Total Recycling Points” column in another table called “Recycling Points Chart”. This table has a slice that uses a filter that shows each user their own data. I tried to create app formula that looked like this:
SUM(Recycling Points Chart[Total Recycling Points]
But that returned the total of every user’s points. So I tried
SUM( Recycling Points Chart slice[Total Recycling Points])
Although that returned the current user’s recycling points, it showed the same number for every user.
So here is my question: Can you help me find a formula that will show each individual user’s total recycling points?