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

Jason -

What I would suggest is to take a look at the Let statement. It allows you to put variables inside your calculation field. For example

Let ( [

var1 = Truncate ( BendDiameter / 12 ; 0 ) ;

var2 = BendDiameter - var1 * 12 ;

var3 = Truncate ( var2 / 1 ; ) ;

{ and so forth }

] ;

rest of calc here

)

HTH

Mike