3 Replies Latest reply on Feb 28, 2011 10:20 AM by philmodjunk

    add to calculation help

    schnook

      Title

      add to calculation help

      Post

      Hello all

      the calculation below changes ' (feet) to meters, when it is entered as say 24', now looking through our database some of our people are entering feet as FT or ft or Ft. (24FT or 24Ft or 24ft)

      Can someone help as to how to add FT, Ft and ft to the script below that if entered that way it will change them to meters as well

      IF ( Right ( self ; 1 ) = "'" ; Round ( Self * 12 * 2.54 / 100 ; 2 ) & "M"; self )

      Am using FMP 11 advanced on a Win XP service pk 3 PC

      Regards

      schnook