Page 1 of 1

HUD document converting feet into inches

Posted: Fri Apr 26, 2019 2:11 pm
by RobbG
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>

Re: HUD document converting feet into inches

Posted: Fri Apr 26, 2019 2:27 pm
by BobRichards
So the question is how to prevent your included text from creating blank lines in addition to your text? What does the rendered document look in the area where you added the formula text?

Re: HUD document converting feet into inches

Posted: Mon May 06, 2019 7:19 pm
by RobbG
Sorry for the delay in getting back to you, I have attached screenshots showing the top and the bottom sections when the code is applied.

Re: HUD document converting feet into inches

Posted: Tue May 07, 2019 9:20 am
by BobRichards
There is not much we can do with the information provided since we don't have the code or full rendered document. I would try printing the document with and without your formulas then compare the docs and determine where the extra space is being created. Once you determine that, see if the extra space is coming from different font size, document scaling or whatever. Try to get a handle on what the exact rendering issue is that way.