How to set custom state for a sum

edighoffer.david · 2024-10-16T08:13:56.754Z

Hi Everyone,

I’ll need some help here, I try to display the total sum for each category.
I guess I have to use a custom state but I’m unable to accomplish what I’d like.

To explain briefly the structure, there are 3 DB : Trip, Category and Equipment.
Trip can have multiple Categories, and Categories multiple Equipments as you can see in the picture.

I’m already using CS to display the categories from the left to the right column, when selecting a trip.

Any idea how I could get the sum for each category?

image1112×501 43.1 KB

Thanks for your help

tunacardak · 2024-10-16T09:49:50.265Z

Hello, welcome to the forum

It seems you can show the correct data in the repeating group. You just need to use :sum function. Did you try it?

edighoffer.david · 2024-10-16T09:55:50.955Z

Ah damn, I’ve just tried that and it worked, it was simpler than expected but without your help I wouldn’t have figured out, thanks @tunacardak!

tunacardak · 2024-10-16T10:08:44.933Z

Learning something from scratch is both a painful and equally enjoyable You can reach out to us here whenever you need anything.