This content has been marked as final.
Show 6 replies
-
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.
-
2. Re: Sum total distance
Ken FlerlageSep 11, 2019 12:26 PM (in response to garreth gomilla)
Any chance you could share a workbook?
-
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.
-
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.
-
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.
-
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.