Sum up

Hello Gliders,

I am asking for your help. In my data table I have a list of transactions from different countries and i want to monitor the threshold related to EU countries as a whole and separated by each EU state.

I created a If->Then column “EU check” True or false for EU country
I created a Query filtering by the “EU check” if EU is true - but i wasn’t able to aggregate the Amount to get the sum
I then tried to use the Rollup function with the previous Query’s > Amount but i can only calculate Count but not Sum.

Now I am stuck… can anyone help me to solve this?
Thank you very much

F


This usually indicates that the source column is not a number type. So that is the first thing to check - make sure the column type of the values you want to sum is a Number type.

2 Likes

Thanks Darren,
this already helped to solve the “sum” issue.

I could do now queries and rollup for each EU country - but isn’t there an easier way?

And secondly If I add another transaction data sheet - is there a computing way to combine both into one (same data structure) new summary data sheet ? I could only find computing fields for columns.

Thank you!

I’m not exactly clear on how you are doing it now. What I would do is have a separate table that lists the countries in a single column, one in each row. Then add a single query + rollup column to that table. That’s about as simple as you can get, I think.

I would advise against that. Creating separate tables that hold essentially the same data is a bad idea with Glide (or any database for that matter), and will always come back and bite you eventually. Keep it all in a single table, it will be much easier to work with.

2 Likes