6 Replies Latest reply on Sep 11, 2019 4:44 PM by Bryce Larsen

Sum total distance

garreth gomilla Sep 11, 2019 11:15 AM

Hello,

I have table with products and each product goes through a various warehouses.

I want to get the product's total distance.

I created a calculated field with the distance formula using GPS coordinates and was able to get the individual distance in miles per row but want to sum the total distance up by product.

Is there a way to sum of the total distance per product while still showing the origin and destination column?

1. Re: Sum total distance

Bryce Larsen Sep 11, 2019 11:30 AM (in response to garreth gomilla)

Hi Garreth,
Have you tried using WINDOW_SUM(SUM([Distance])? You should be able to use this window function and have it restart every Product ID.
Like Show 0 Likes(0)

Actions
2. Re: Sum total distance

Ken Flerlage Sep 11, 2019 12:26 PM (in response to garreth gomilla)

Any chance you could share a workbook?
Like Show 0 Likes(0)

Actions
3. Re: Sum total distance

garreth gomilla Sep 11, 2019 1:53 PM (in response to Bryce Larsen)

Hey Bryce,

That calculation sums up the entire miles and not the miles specific for the product.
Like Show 0 Likes(0)

Actions
4. Re: Sum total distance

Bryce Larsen Sep 11, 2019 1:55 PM (in response to garreth gomilla)

Hi Garreth,
You should be bale to modify the table calculation to Restart Every Product ID.
Like Show 0 Likes(0)

Actions
5. Re: Sum total distance

garreth gomilla Sep 11, 2019 4:22 PM (in response to Bryce Larsen)

I did and it only shows the row level distance not the overall distance of the product.
Like Show 0 Likes(0)

Actions
6. Re: Sum total distance

Bryce Larsen Sep 11, 2019 4:44 PM (in response to garreth gomilla)

Are you able to share a sample of the data? Then Ken Flerlage or myself could have a look.
Like Show 0 Likes(0)

Actions