4 Replies Latest reply on Mar 5, 2013 5:53 AM by Michael Kofoed

    What is wrong with this calculation

    Michael Kofoed

      What is wrong with this caluculations.

      I have tried to copy the formula from the Tableau video.

       

      [Earth_radius] * acos (

      COS([K]* avg([GEO_LAT]))* COS ([K]*avg([GEO_LNG]))* COS ([K]*[GEO_LAT1]) * cos ([K]*[GEO_LNG1])
      + COS([K]* avg([GEO_LAT])) * SIN ([K]*avg([GEO_LNG])) * COS([K]*[GEO_LAT1]) * SIN([K]*[GEO_LNG1])
      + SIN([K]* avg([GEO_LAT])) * SIN([K]*[GEO_LAT1])

      )RADIANS([GEO_LNG1])

      )

       

      Can anybody help