10 Replies Latest reply on Jun 29, 2012 1:58 PM by comment

    Calculations using Variables

    Jason_Farnsworth

      Is it possible to combine these five functions into one calculation?

       

      //Truncate ( BendDiameter/12 ;0 )

      //BendDiameter-(BendDiameter1stCal*12)

      //Truncate (BendDiameter2ndCal/1 ; 0 )

      //Fractions32 (BendDiameter2ndCal - BendDiameter3rdCal)

      //If ( BendDiameter4thCal = +1 ; BendDiameter1stCal & "'" & " - " & BendDiameter3rdCal+1 & """ ; BendDiameter1stCal & "'" & " - " & BendDiameter3rdCal & " " & BendDiameter4thCal & """)

       

      What I am trying to accomplish is taking a number that is in inches convert it to feet & inches for a printed display. I can do this with 5 seperate fields one for each each taking 1 step at a time.

       

      Is it possible to use variables in a field calculation? If so how would I structure the formula to use them?

       

      Thanks in advance

       

      Jason