1

enter image description here

I need some help in calculating the last column (OD_pairs.Ai_) based on the condition; if travel_cost has a value below 10, OD-pairs.Ai_ takes the value of the first column(Aij_OjFCij..) if travel_cost has a value above 10, then return 0 in OD_pairs.Ai. So basically the third field to be calculated is either the corresponding value in the first field or zero, depending on the value in second field.

PolyGeo
  • 65,136
  • 29
  • 109
  • 338
Aivin
  • 45
  • 6

1 Answers1

2

My solution is in Python, don't forget to switch to Python Parser in the Field Calculator window.

You asked for:

Pre-Logic Script Code:

def calcColumn(cost, Aji):
  if cost < 10:
    return Aji
  elif cost > 10: 
    return 0

OD_pairs.Ai_ = 

calcColumn(!Travel_Cost!, !Aij_OjFCij_Income4!)

Bare in mind if you have cost = 10, it won't work, as it only handles larger than or smaller than 10. You can also instead use:

Pre-Logic Script Code:

def calcColumn(cost, Aji):
  if cost < 10:
    return Aji
  else:
    return 0
Blerg
  • 646
  • 5
  • 13