Want to get involved? We're always looking for ideas and content for Weekly Challenges.
My solution below.
if [Row-1:Site]="Hotel" and [Site]="Hotel" then 0 else ST_Distance([Row-1:SpatialObj],[SpatialObj],"Mi")endif
Good to practice spatial tools
Somewhat different solution.