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.
أكثر...