How to set custom state for a sum

[edighoffer.david]

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?

Thanks for your help

[tunacardak]

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]

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]

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