Occupancy Count Worksheet

[Tom Klaber]

 

This should be simple, but I am having trouble.  I want to have a worksheet that auto-calculates the occupancy load based on the area of a space.  Spaces have an input for square feet per person - so it seems like I should be able to create a column that simply divides the area by this variable and display the answer - but I can not figure out what I am missing.

 

So far I have:

=(('Space'.'11_Area')/('Space'.'SpaceOccupancyRequirements_AreaPerOccupant'))

 

I have tried with and without parenthesises.  

 

Is this even possible to do this calculation in a database since the resulting number has nowhere to live inside the object?

 

 

[rDesign]

@Tom Klaber- maybe this worksheet posted in another thread by @Wes Gardnermight help answer your question.

 

 

[Pat Stanford]

Space.'11_Area' is a text field so it includes the unit marks.  Try using Space.Area instead.

 

_AreaPerOccupant is already a numeric field.

[Tom Klaber]

Thanks!

Getting closer.