Schedule units, number vs. text fields

[patricks]

Is there a way to have a text field in a schedule display the numerical value from another field through a formula?

I'm trying to get my occupancy schedule's Area/Occupant column to display "N/A" for fixed seating areas. Thought I could do it through a calculated value set to Text, but it's saying Inconsistent Units.

The formula is if((S.F.PerPerson > 0), S.F.PerPerson, Comments) which basically says if the area per occupant is greater than 0, just display the area per occupant number. Otherwise, use the value of the Comments field which I have set to N/A for area functions with fixed seating.

[LP Design]

As far as I know there is no good way to do this. It is one of my frustrations about trying to automate the life safety analysis. Each column is based on a parameter, so you can't mix-and-match what type of values go in that column. You are either using numbers or letters, but not both.

The only thing I can suggest is to use your formula to override the value to say "000" or something and then write the occupancy in an adjacent text column (remarks maybe).

I have my schedules set up so that the calculated value is not shown on the printed schedule, rather there is a QC schedule that shows the calculated value and a "check" column that will turn red if the values don't match. So it's not automatic, but the user just has to make sure that nothing shows up red. In the case of a fixed seating area you just ignore the red box and put in the number of seats. It's not perfect, but it seems to be working so far.

-LP