Forum Discussion
Solved
New Column - Using related function "parameter is not the correct type"
Hi, I am trying to create a new column in order to calculate the distance between locations using latitude and longitude. To do this I created a new column under one sheet and used the related funct...
I'm not sure this is the extent of the problem you are facing, but at the very least you need a closing parentheses after Active_Nonprofit_Network[NPO].
Distance = ACOS(SIN(RELATED(Active_Nonprofit_Network[NPO]) * PI()/180)))
I'm not sure this is the extent of the problem you are facing, but at the very least you need a closing parentheses after Active_Nonprofit_Network[NPO].
Distance = ACOS(SIN(RELATED(Active_Nonprofit_Network[NPO]) * PI()/180)))
Thank you, all good now! Haha not sure how this didn't occur to me
