Solved! Go to Solution.
Dim CarOrientation Dim RoadOrientation RoadOrientation = [CarData_RoadLinks_Statistics.Orientation] Dim RoadCompass RoadCompass = [CarData_RoadLinks_Statistics.CompassA] Dim RoadCompassMax RoadCompassMax = RoadCompass + 170 If RoadCompassMax > 360 Then RoadCompassMax = RoadCompassMax - 360 ElseIf RoadCompassMax < 0 Then RoadCompassMax = RoadCompassMax + 360 End If Dim RoadCompassMin RoadCompassMin = RoadCompass - 170 If RoadCompassMin > 360 Then RoadCompassMin = RoadCompassMin - 360 ElseIf RoadCompassMax < 0 Then RoadCompassMin = RoadCompassMin + 360 End If Dim PointBearing PointBearing = [CarData_RoadLinks_Statistics.Bearing] If PointBearing > RoadCompassMin And PointBearing < RoadCompassMax Then CarOrientation = RoadOrientation End if If PointBearing < RoadCompassMin Or PointBearing > RoadCompassMax Then If RoadOrientation = "-" Then CarOrientation = "+" End if If RoadOrientation = "+" Then CarOrientation = "-" End if End if
Hi,
Thank you, I now understand why I cannot see both the entries for each TOID with a join.
I think I have the answer to your question: the summary cannot work with the null values as null is not automatically assumed to be 0 in a numeric field? - Therefore it would be looking for the min or the max of nothing?
Thanks again,
Liam.
You really only need the Max of FromTo and ToFrom, since you don't care about the Null if a non-Null value exists. The only time you might care about a Min and Max is if you somehow had two different non-Null values for a single direction, which as I understand it, makes no sense for your model.