Hi all!
I need to create a formula to sum the distance [Km] of some travels [Travel].
All these travels has 3 dates to identify it: the start date [Date Start], a checkpoint date [Date Middle] and an end date [Date End].
I want only to sum the distance of the travels which have at least one of the 3 dates included in the range shown at the end of the sample
[Date Start Evaluation] for the earliest date possible
[Date End Evaluation] for the latest date possible
How can I do it? Thank you very much
Here is one way of doing it:
I've made it so it should be dynamic as well - append the Evaluation dates onto the data and then using a Formula tool it compares to see if each date is within the evaluation parameters; returning True or False if any of the 3 dates match. Then it filters on true and sums the KM for these.
