AnsweredAssumed Answered

Calculations using Variables

Question asked by Jason_Farnsworth on Jun 28, 2012
Latest reply on Jun 29, 2012 by comment

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

Outcomes