I desire to have a ratio calculated each time I create a new route.

To get this ratio, I created and populated a field that multiplied the length of each segment by a designated number from 1-5, where 1 was most desirable, we'll call this [FieldValue]. Theoretically, when divided by the length, this would produce a value that, the closer to 1 would indicate a more desirable route.

In the field evaluator value dialogue box, I was able to divide my calculated value by the length of the segment ([FieldValue]/[Length]). I was hoping that they would sum each field first and then divide the two values at the end.

However, when I ran the route analysis, the values were dividing each row, and summing all of the individually divided values at the end.

I would like each field, [FieldValue] and [Length] to sum first, then divide the two summed fields to produce the ratio. It would appear that I can do this with a VB script or Prelogic within the network analyst evaluator value field, but I lack the programming skills to do so.

What would be the best route to take in order to have them calculate in my desired order?

closed as unclear what you're asking by PolyGeo, Simbamangu, Fezter, Paul, Devdatta Tengshe Mar 17 '14 at 2:48

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • What version of ArcGIS for Desktop are you using to try and do this? Is using Python rather than VBScript an option for you? Please edit your Question to revise it with these clarifications and anything else you think relevant that may have come to light since you asked this Question over three years ago. – PolyGeo Mar 16 '14 at 3:33