On my platform, the user can enter an amount and an associated category saved to one collection called payments. I need some help displaying the sum of the categorized amounts—for example, all the payments in the grocery category. Any help would be appreciated. Thanks
Repeating group with the datatype Text, datasource would be Do a search for Payment:each item's Category
Inside the cell put a text element, datasource would be Do a search for Payment, with a constraint Category = Current cell's text, then after the search do :each item's Amount:sum
Might also want some text inside saying the Current cell’s text so there is a Category title for each cell (or do it in the same text element as the sum)
This could prob be done without a RG if you just want like a vertical list in a text element too using the :formatted as text operator
Thank you for the help but when I tried it I got repeat categories:
Also, I tried to do it without a RG but I kept running into errors… I may need to break categories into a separate data type. What do you think?
Do :unique elements after the category search.
I do agree though you’re better off making a Category datatype.
I ended up going with the category data base then filtering the records based on the created user. This was definitely the right choice.
1 Like