Pulling Sub totals from a Gallery

(0) Share

Report

Posted on by GF-02121351-0

239

Hi,

I am trying to get sub totals for the items in my Expense Gallery.

Sum(GalleryExpenses.AllItems, Filter ('Exp Category' "Meal", GalCost))

Travel App Expenses Sub.png

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (11)

Answers (1)

KRider 577 Super User 2024 Season 1 on at

Like (1)

Report
Re: Pulling Sub totals from a Gallery

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))

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report

Re: Pulling Sub totals from a Gallery

@KRider that would work if I wanted all items, but I am trying to do sub totals by category.

Was this reply helpful? Yes No
KRider 577 Super User 2024 Season 1 on at

Like (1)

Report

Re: Pulling Sub totals from a Gallery

Right, then you would filter the gallery itself first? or no can do?

Was this reply helpful? Yes No
KRider 577 Super User 2024 Season 1 on at

Like (1)

Report
Re: Pulling Sub totals from a Gallery

Try this one out.
Sum(GalleryExpenses.AllItems, If(ThisRecord.Category="Meal",Galcost))

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report
Re: Pulling Sub totals from a Gallery

Sum(GalleryExpenses.AllItems, "Meal" + GalCost))
When I tried this it gave me the total of all items.

Sum(GalleryExpenses.AllItems, If(ThisRecord.Category="Meal",Galcost))
For this one I get an "Incompatible types error. These types cannot be compared. Error: Text"

Was this reply helpful? Yes No
Verified answer

KRider 577 Super User 2024 Season 1 on at

Like (2)

Report
Re: Pulling Sub totals from a Gallery

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))

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (1)

Report

Re: Pulling Sub totals from a Gallery

That is where I messed up. I called it Exp Category.

Thank you, I am all set.

Was this reply helpful? Yes No
KRider 577 Super User 2024 Season 1 on at

Like (0)

Report

Re: Pulling Sub totals from a Gallery

No problem! 😄

Was this reply helpful? Yes No
yirga 6 on at

Like (1)

Report

Re: Pulling Sub totals from a Gallery

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!

Was this reply helpful? Yes No
GF-02121351-0 239 on at

Like (0)

Report

Re: Pulling Sub totals from a Gallery

Hi Yirga,
In your dataset what are your column headings? Do you have one entry per program?

Was this reply helpful? Yes No