Hi Everyone,

In a RG, I have lines into categories, and I get the sum for each category with :sum

I’m trying to calculate the grand total of all of this sums, is that possible?

In the example below, how to get the total of 500 + 300 + 1800 which are obtained with the function :sum?

Thanks for your help

Can you share the structure of your Data Types?

Sure I have created 3 DB: Catogy, Equipment, Trip

Each trip can have multiple categories, and each category can have multiple equipments

How about the Trip Data Type?

Here is the Trip Data type:

Is this how you structure your Equipment Data Type?

Almost, few more fields but they are not really important for this task

This is working perfectly you nailed it!

Thanks so much @cyril.legaspi you made my day

1 Like