Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis macro finds the next closest delivery location so Flora's total miles is a bit less. I also played around with the reporting tools:
As dsmdavid pointed out, there's a difference when you restrict the dataset to the 30 customers closest to the flower shop versus going to the closest customer based on the previous delivery. I did the most efficient route and my iterative macro is based on the latter option.
Since I'm fairly new to iterative macros, I referenced the Santa's First Iterative Macro Community training which was a great resource.
Iterative macro: