This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm looking to achieve the % weight and % number of shipments per lane. I thought this could be achieved via the use of the weighted average tool, but can't seem to get this to work how I want it. Below is an example of the output that I need and I've attached the data I'm inputting into the workflow;
Thanks for your reply to my post, I have actually achieved what I wanted by using a formula tool. The result I wanted was at city to city level as country can be rolled up out of this. For anything null, yes, this would be considered as 0 movements.