I have a formula set up to calculate the square footage of the stone needed for stone wall construction. I have an entryway that is about 13' high, about 8' wide, and has an arched opening. Its part of the front porch entry into the house.
The formula is set up as the Wall > Wall type.
When I use the variable 'area' to calculate the square footage, it shows about 130 sq ft, which is correct, not taking the opening into consideration.
When I use 'wall_area_no_open' (which is what I need...) it doesn't show up at all in my report, so I'm guessing it's coming up with zero, or less than zero.
Just to test, I also tried using just 'open_area' variable.. and it correctly calculates the area of the opening.
The variable 'area' minus 'open_area' should equal the value returned by 'wall_area_no_open', but it does not. What gives? Am I speaking spanish? Hope this makes sense. The value I need (wall_area_no_open) is not working correctly; it won't return a value. The 'area' variable and the 'open_area' work correctly though.