We've got a system for adding the "Programmed Area" for all of our Rooms.
Then we have a Calculated Value for Over/Under (Area - ProgrammedArea) and another for Variance (Area / ProgrammedArea).
This all works pretty well for comparing the Actual Areas to the building Program. I'm having a problem, though with the "Not Placed" Rooms. Their Area shows in the schedule as "Not Placed", which is OK, I guess, but I'd like to be able to report that area as 0 in the other Calculated Values. Those field just show up as blank now (see image). That means that the "Over/Under" does not report anything for a Not Placed Room instead of reporting the Programmed Area, which makes my Totals wrong.
Tried making another Calculated Value field and setting it to equal Area, but it's blank, too.
Is there any way I can get a usable number from a "Not Placed" Room?