
1. Re: Calculation Field Format  How to Override
philmodjunk Feb 4, 2013 10:34 AM (in response to VanessaAnne)The field should not be modifiable. I don't see a reason why you need it to be either.
It would appear you need a calculation that takes text from fields of type text, extracts the feet and inches as separate values, add themadjusting the results to be displayed in feet and inches with the inches always less than 12.
Let's say field A is a text field with your first measuremnt in 5' 6" format. Field A is a text field with the same type of measurement in identical format.
Your calculation could be:
Let ( [ Af = GetAsNumber ( Leftwords ( FieldA ; 1 ) ) ;
Ai = GetAsNumber ( Rightwords ( FieldA ; 1 ) ) ;
Bf = GetAsNumber ( Leftwords ( FieldB ; 1 ) ) ;
Bi = GetAsNumber ( Rightwords ( FieldB ; 1 ) ) ;
Iab = Ai + Bi
];
Af + Bf + Div ( Iab ; 12 ) & "' " & Mod ( Iab ; 12 ) & "\""
) 
2. Re: Calculation Field Format  How to Override
VanessaAnne Feb 4, 2013 10:53 AM (in response to VanessaAnne)Thank you. This is what I've entered. Field A = Camera Height from Floor. Field B = Floor Height from Camera
I am getting an error message  please see attached. referring to the first "["
( [ Camera Height From Floor = GetAsNumber ( Leftwords ( Camera Height From Floor ; 1 ) ) ;Camera Height From Floor = GetAsNumber ( Rightwords ( Camera Height From Floor ; 1 ) ) ;Camera Height From Ground = GetAsNumber ( Leftwords ( Floor Height From Ground ; 1 ) ) ;Camera Height From Ground = GetAsNumber ( Rightwords ( Floor Height From Ground ; 1 ) ) ;Iab = Camera Height From Floor + Camera Height From Ground];Camera Height From Floor + Camera Height From Ground + Div ( Iab ; 12 ) & "' " & Mod ( Iab ; 12 ) & "\"") 
3. Re: Calculation Field Format  How to Override
philmodjunk Feb 4, 2013 11:04 AM (in response to VanessaAnne)You appear to be missing the name of the enclosing funciton: Let.
And you will not get the correct results even with this correction. You need to have 5 distinct variables where you currently have these three:
Camera Height From Floor, Camera Height From Ground, Iab
To explain how I named the variables in my suggested example:
Af stands for "feet from Field A"
Ai stands for "inches from Field A"

4. Re: Calculation Field Format  How to Override
VanessaAnne Feb 4, 2013 11:23 AM (in response to VanessaAnne)Gotcha. The calculation is resulting now but it doesn't seem correct.
These are the values I'm working with:
Field A = Camera Height from Floor. 5'6"
Field B = Floor Height from Camera. 0'0"
Calculated result = 66'2" (when it should be 5'6" since the floor height and camera height are the same in this instance)

5. Re: Calculation Field Format  How to Override
philmodjunk Feb 4, 2013 11:35 AM (in response to VanessaAnne)Please read my last post again:
You apparently have this calculation:
Let ( [ Camera Height From Floor = GetAsNumber ( Leftwords ( Camera Height From Floor ; 1 ) ) ;
Camera Height From Floor = GetAsNumber ( Rightwords ( Camera Height From Floor ; 1 ) ) ;Camera Height From Ground = GetAsNumber ( Leftwords ( Floor Height From Ground ; 1 ) ) ;Camera Height From Ground = GetAsNumber ( Rightwords ( Floor Height From Ground ; 1 ) ) ;Iab = Camera Height From Floor + Camera Height From Ground];Camera Height From Floor + Camera Height From Ground + Div ( Iab ; 12 ) & "' " & Mod ( Iab ; 12 ) & "\"")You are using the same variable name for both inches and feet from the same field. Where you use the same name twice in red, you need two different names. The same is true for where you use the same name twice in blue.One possible way that you could correct this:Let ( [ Camera Height From FloorFeet = GetAsNumber ( Leftwords ( Camera Height From Floor ; 1 ) ) ;
Camera Height From FloorInches = GetAsNumber ( Rightwords ( Camera Height From Floor ; 1 ) ) ;Camera Height From GroundFeet = GetAsNumber ( Leftwords ( Floor Height From Ground ; 1 ) ) ;Camera Height From GroundInches = GetAsNumber ( Rightwords ( Floor Height From Ground ; 1 ) ) ;Iab = Camera Height From Floor Inches + Camera Height From Ground Inches];Camera Height From Floor Feet + Camera Height From Ground Feet + Div ( Iab ; 12 ) & "' " & Mod ( Iab ; 12 ) & "\"") 
6. Re: Calculation Field Format  How to Override
VanessaAnne Feb 4, 2013 11:41 AM (in response to VanessaAnne)Yes, thank you that worked. I had something switched around. Very much appreciate it.