Sum of fields changing over time

[filipembribeiro]

Hi all!

I have this dataset

In 01/01/23 and 02/01/23 the groups C and D were part of Location USA.

But in 03/01/23 the group B shifted its location, joining C and D in Location USA.

I want to calculate:

Sum of Total Distance: 1750

( Sum of Distance of C and D starting 01/01/23 until 02/01/23 + Sum of Distance of B, C and D starting 03/01/23)

How can I sum the total Distance of categories if the set (Location) of categories change its members over time?
Do I have to create a workflow which break the sum with an IF formula?

Thank you all very much!!

[binuacs]

@filipembribeiro Filtering the location and taking the sum of distance would work for you.