Which video ?
All I can see is that your first acos() calc ends it's final bracket just before RADIANS and between that bracket and Radians is no operator? Then the final bracket is one too many.
Put it in an editor like notepad++ that highlights closing brackets when you select the opening one and it will be clearer.
Thank you. I will do that. But there was another problem too. It would not mix the not avg with the avg.
The video i look at was in On demand, Advanced, Mapping
I will work some more with it
See attached workbook. I think it depends on how you have calculated your Latitude and Longitude that you compare with. If that is a straight value, then you're trying to calculate with summarized and unsummarized data and it will error. I've calculated my comparison latitude/longitude using a summarizing formula, so it doesn't have that problem.
I've NO idea if this is actually the way it is supposed to work, but it seems to work okay. I also didn't know where to get the data from, so I've just picked a list of a website somewhere.
At least it gives a general idea and hopefully helps you further?
Distance Mapping Test.zip 70.5 KB
Thank you very much. That is precisely what I need to make my view