HUD document converting feet into inches
Posted: Fri Apr 26, 2019 2:11 pm
The Manufactured Home Application for Duplicate Certificate of Title requires the length and width in inches, my escrow staff does not want to do the math, so they put it in Select as feet.
I pulled the formula out of the document section and was able to get the math to work which is pretty easy math. The full formula with my calculations is below. The issue I am running into is once I post the formula's below back into the section on the document it pushes the document to the next page and I can't figure out how to get it to stay as it was. There was not that much I added. What can I do to keep it looking the same?
LENGTH FULL FORMULA
<IF (InString(<CALC ({{.ManufacturedHousing.Length}}*12)>,"/")>-1)><VAR $BeforeSlash1 ((InString(<CALC ({{.ManufacturedHousing.Length}}*12)>,"/"))-1)><VAR $Length1 (SubString(<CALC ({{.ManufacturedHousing.Length}}*12)>,1,{{$BeforeSlash1}}))><VAR $AfterSlash1 ((InString(<CALC ({{.ManufacturedHousing.Length}}*12)>,"/"))+1)><VAR $TheRest1 (SubString(<CALC ({{.ManufacturedHousing.Length}}*12)>,{{$AfterSlash1}},50))><IF (InString({{$TheRest1}},"/")>-1)><VAR $BeforeSlash2 ((InString({{$TheRest1}},"/"))-1)><VAR $Length2 (SubString({{$TheRest1}},1,{{$BeforeSlash2}}))><VAR $AfterSlash2 ((InString({{$TheRest1}},"/"))+1)><VAR $TheRest2 (SubString({{$TheRest1}},{{$AfterSlash2}},50))><VAR $Length3 ({{$TheRest2}})><ELSE><VAR $Length2 ({{$TheRest1}})></IF>{{$Length1}}<ELSE><CALC ({{.ManufacturedHousing.Length}}*12)></IF>
WIDTH FULL FORMULA
<IF (InString(<CALC ({{.ManufacturedHousing.Width}}*12)>,"/")>-1)><VAR $BeforeSlash1 ((InString(<CALC ({{.ManufacturedHousing.Width}}*12)>,"/"))-1)><VAR $Width1 (SubString(<CALC ({{.ManufacturedHousing.Width}}*12)>,1,{{$BeforeSlash1}}))><VAR $AfterSlash1 ((InString(<CALC ({{.ManufacturedHousing.Width}}*12)>,"/"))+1)><VAR $TheRest1 (SubString(<CALC ({{.ManufacturedHousing.Width}}*12)>,{{$AfterSlash1}},50))><IF (InString({{$TheRest1}},"/")>-1)><VAR $BeforeSlash2 ((InString({{$TheRest1}},"/"))-1)><VAR $Width2 (SubString({{$TheRest1}},1,{{$BeforeSlash2}}))><VAR $AfterSlash2 ((InString({{$TheRest1}},"/"))+1)><VAR $TheRest2 (SubString({{$TheRest1}},{{$AfterSlash2}},50))><VAR $Width3 ({{$TheRest2}})><ELSE><VAR $Width2 ({{$TheRest1}})></IF>{{$Width1}}<ELSE><CALC ({{.ManufacturedHousing.Width}}*12)></IF>
I pulled the formula out of the document section and was able to get the math to work which is pretty easy math. The full formula with my calculations is below. The issue I am running into is once I post the formula's below back into the section on the document it pushes the document to the next page and I can't figure out how to get it to stay as it was. There was not that much I added. What can I do to keep it looking the same?
LENGTH FULL FORMULA
<IF (InString(<CALC ({{.ManufacturedHousing.Length}}*12)>,"/")>-1)><VAR $BeforeSlash1 ((InString(<CALC ({{.ManufacturedHousing.Length}}*12)>,"/"))-1)><VAR $Length1 (SubString(<CALC ({{.ManufacturedHousing.Length}}*12)>,1,{{$BeforeSlash1}}))><VAR $AfterSlash1 ((InString(<CALC ({{.ManufacturedHousing.Length}}*12)>,"/"))+1)><VAR $TheRest1 (SubString(<CALC ({{.ManufacturedHousing.Length}}*12)>,{{$AfterSlash1}},50))><IF (InString({{$TheRest1}},"/")>-1)><VAR $BeforeSlash2 ((InString({{$TheRest1}},"/"))-1)><VAR $Length2 (SubString({{$TheRest1}},1,{{$BeforeSlash2}}))><VAR $AfterSlash2 ((InString({{$TheRest1}},"/"))+1)><VAR $TheRest2 (SubString({{$TheRest1}},{{$AfterSlash2}},50))><VAR $Length3 ({{$TheRest2}})><ELSE><VAR $Length2 ({{$TheRest1}})></IF>{{$Length1}}<ELSE><CALC ({{.ManufacturedHousing.Length}}*12)></IF>
WIDTH FULL FORMULA
<IF (InString(<CALC ({{.ManufacturedHousing.Width}}*12)>,"/")>-1)><VAR $BeforeSlash1 ((InString(<CALC ({{.ManufacturedHousing.Width}}*12)>,"/"))-1)><VAR $Width1 (SubString(<CALC ({{.ManufacturedHousing.Width}}*12)>,1,{{$BeforeSlash1}}))><VAR $AfterSlash1 ((InString(<CALC ({{.ManufacturedHousing.Width}}*12)>,"/"))+1)><VAR $TheRest1 (SubString(<CALC ({{.ManufacturedHousing.Width}}*12)>,{{$AfterSlash1}},50))><IF (InString({{$TheRest1}},"/")>-1)><VAR $BeforeSlash2 ((InString({{$TheRest1}},"/"))-1)><VAR $Width2 (SubString({{$TheRest1}},1,{{$BeforeSlash2}}))><VAR $AfterSlash2 ((InString({{$TheRest1}},"/"))+1)><VAR $TheRest2 (SubString({{$TheRest1}},{{$AfterSlash2}},50))><VAR $Width3 ({{$TheRest2}})><ELSE><VAR $Width2 ({{$TheRest1}})></IF>{{$Width1}}<ELSE><CALC ({{.ManufacturedHousing.Width}}*12)></IF>