Originally Posted by
jcs1112
Basically I am trying to pull the total sq ft. of house based on what is entered into my title block in a field which in turn pulls from a table and if its greater than 2571 to display on the print that the house will require an AC label ,or state that its just a std. house otherwise. Now having the sq ft displayed in my title block as a field i have figured out. This is the diesel formula I'm trying to make work inside a field:
$(if,$(EQ,$(>=,%<\AcExpr (Table(%<\_ObjId 2127028848>%).A2*Table(%<\_ObjId 2127028848>%).B2) \f "%lu2%pr0">%,2571),1),"SF IS GREATER THAN 2571 - REQUIRES AC LABEL","STD. HOUSE")
And its actually works when I pick ok to leave the field dialog box, but only once.
This part of the formula:
%<\AcExpr (Table(%<\_ObjId 2127028848>%).A2*Table(%<\_ObjId 2127028848>%).B2) \f "%lu2%pr0">%
disappears and is replaced with the number that was calculated, lets say for example that number was 2625, this is what happens to the formula once I pick ok
$(if,$(EQ,$(>=,2625,2571),1),"SF IS GREATER THAN 2571 - REQUIRES AC LABEL","STD. HOUSE")
Is there any way to keep the formula from losing object info?