AnsweredAssumed Answered

add to calculation help

Question asked by schnook on Feb 26, 2011
Latest reply on Feb 28, 2011 by philmodjunk


add to calculation help


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