There is nothing in particular wrong with your formula - what you are seeing is a limitation of the ability of formula properties to deal with embedded double quotation marks, which are used both to delimit text strings and to indicate inches in imperial units. If you want a formula property to have a result of 3'-0" x 7'-0", then you are going to have to start with the raw numbers and build the string within the formula itself. You will not be able to take the automatic property value, formatted for feet and inches, and pass it through a formula property.
Building the string is not all that hard (use CHR(34) to generate the inches mark when concatenating the final result string), but since you also are using the "PR" variant, you would also have to track the door type, then build the string accordingly. For example, a Width of 4'-0" would be reported as 4'-0" for a single swing door, PR 2'-0" for a pair of doors or a pair of sliders, 3'-0"(1'-0") for an uneven pair of doors if the leaf width is 3'-0", 2 @ 2'-0" for a bifold door, 3 @ 1'-8" for a triple slider and 4 @ 1'-0" for a double bifold. (There may be other variants; and yes, I do realize that 4'-0" is not an appropriate real-life width for all of those door types.)
Creating a formula property that could do the above has long been on my "when I get around to it" list, so that I could have a single schedule that includes both Doors and Door/Window Assemblies with a single opening column following the Door "PR" format, but I have never "gotten around to it". It has been on the list so long that I am begining to think that I never will find the time to do it. On real-life projects, I generally use a cased opening Door object on the Door Schedule and then either put that on a non-plotting layer and place the Door/Window Assembly to generate the graphics -OR- skip the DWA altogether and use the cased opening Door object to show the frame and fake in the rest of the graphics. BIM blasphemy? You bet, but when you are only using the "model" for the plan and the project needs to get done and the schedule does not include 40 hours to customize a formula property, you do what you need to do.
David Koch
AutoCAD Architecture and Revit User
Blog | LinkedIn