Announcements
Hi,
I am trying to get sub totals for the items in my Expense Gallery.
Sum(GalleryExpenses.AllItems, Filter ('Exp Category' "Meal", GalCost))
Just needs to be the column you want to reference.
Sum(GalleryExpenses.AllItems, galcost)
If there are multiple columns you wish to add then you would write:
Sum(GalleryExpenses.AllItems, "Meal" + GalCost))
@KRider that would work if I wanted all items, but I am trying to do sub totals by category.
Right, then you would filter the gallery itself first? or no can do?
Try this one out.
Sum(GalleryExpenses.AllItems, If(ThisRecord.Category="Meal",Galcost))
When I tried this it gave me the total of all items.
For this one I get an "Incompatible types error. These types cannot be compared. Error: Text"
Ok, for your table is the category Column named Category? Thats what we are referencing here.
Sum(GalleryExpenses.AllItems, If(ThisRecord.CategoryCOLUMN=(Whatevercategory you want), Galcost))
You could also create a drop down of your categories and make the code like this:
Sum(GalleryExpenses.AllItems, If(ThisRecord.Category=DropDown1.Selected.Value,Galcost))
That is where I messed up. I called it Exp Category.
Thank you, I am all set.
No problem! 😄
Is there a way to implement Totals and and Subtotals in a Gallery without repeating Header? Example: In a Department there 20 offices, in each office there are at least 3 Programs, and in each program there are at least 2 sub-Programs. So, is there a way to calculate subtotals of Sub-Programs, Sub-Totals of Sub-Programs, and so on.. Within a Gallery? Thanks!
Hi Yirga,
In your dataset what are your column headings? Do you have one entry per program?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 542 Most Valuable Professional
Haque 206
Kalathiya 201 Super User 2026 Season 1