use schedule totals as part of formula

[3dsketcher]

can i use schedule totals as part of formula?

example 1

office A 12 SF
office B 18 SF
conf C 11 SF
conf D 19 SF
total 60 SF

can i then in the same reuse 60 as a fraction to get
12/60 at same row as room A?
18/60 at same row as room B?
11/60 at same row as room C?
19/60 at same row as room D?

[Steve_Stafford]

If you are seeking a percentage of the Gross Area, yes in a fashion. See attached image. Otherwise no, Revit does not permit us to create a query of the results of a query like Access or other database applications will.

[3dsketcher]

cool! thanks steve. this is exactly what i want.

i have another question though. in this example

officeA 5 rooms 5 people
officeB 3 rooms 6 people
officeC 2 rooms 2 people

can i decide to multiply only one row to a certain number? something to this logic
if room = office B then *2, else rooms.

=IF (Name = "officeB", Rooms*2, Rooms)
i cant seem to get the formula correct
=IF (<condition>, <result-if-true>, <result-if-false>)

[Steve_Stafford]

Sorry I'm a little math/logic challenged...what are you trying to accomplish? Is this an occupancy calculation?

[3dsketcher]

no. this is just to get the number of people we have provided offices. some have 2 persons in one office thats why.

[Steve_Stafford]

With Revit you need to ask several questions depending how you want data summarized. If you want a report that breaks down rooms by the number of people assigned to a room then you need to state your question differently in a separate schedule. Think of a schedule as asking Revit a question. You only get to ask "one" question and can't ask another question of the results of a previous question.

[3dsketcher]

thanks again steve. although i'm not sure i understand your example. were the numbers under the 'people assigned' and 'count' using formulas or a manual input?

i might have stated my initial question wrong. i basically want to apply the same condition to all of column B and it's just that i know that all office B's have automatically 2 people assigned therefore i know office A and office C will result as False therefore carryover the original count and that office B will result as True hence it gets multiplied by 2.

can you help me with this formula?
=IF (Name = "officeB", Rooms*2, Rooms)

[dbaldacchino]

Sounds like what you're after can be achieved with a key schedule, where you would select "Office A" or "Office B" and the information pertaining to that space (ex: the number of people in each office) would automatically populate. THen you can calculate totals from that parameter.

[3dsketcher]

thanks dave. just to be sure, are you saying that any mutiplication on the true/false formula would not work?

ill try the key sched as well.

[dbaldacchino]

I don't think you can do if statements like that in calculated values within schedules. For sure, you cannot test for a string and return a number based on it, such as "if(Name="Office A", 1, 2). Revit won't accept that.