Grand Totals inside Calculated Formula

Grand Totals inside Calculated Formula

zakim
Enthusiast Enthusiast
1,584 Views
7 Replies
Message 1 of 8

Grand Totals inside Calculated Formula

zakim
Enthusiast
Enthusiast

Hello,

In Revit area schedule, I am trying to take the "Grand Total" in an Area schedule then use it in a calculated parameter.

 

Is this possible? Please see image capture below. I appreciate any pointers.

 

0 Likes
Accepted solutions (1)
1,585 Views
7 Replies
Replies (7)
Message 2 of 8

ralphdenhaan
Collaborator
Collaborator

Hi,

 

See print screen:

 

ralphdenhaan_0-1694691660263.png

 

Select Accept as Solution and Likes are always welcome. 


Ralph den Haan, (Lazy) BIM Specialist


LinkedIn | LazyBIM Blog


 

Message 3 of 8

zakim
Enthusiast
Enthusiast

Thank you @ralphdenhaan. This worked well and I will accept it as solution.

Can I ask another question: how can I take the grand total and put it in calculated parameter. Please see capture below.

 

zakim_0-1694693087298.png

 

0 Likes
Message 4 of 8

ralphdenhaan
Collaborator
Collaborator

Something like this?

 

ralphdenhaan_0-1694695197001.png

 

Select Accept as Solution and Likes are always welcome. 


Ralph den Haan, (Lazy) BIM Specialist


LinkedIn | LazyBIM Blog


 

Message 5 of 8

zakim
Enthusiast
Enthusiast

Not really. I would like to take the "Grand Total" value and multiply it by a factor (e.g. 0.3

0 Likes
Message 6 of 8

ralphdenhaan
Collaborator
Collaborator
Accepted solution

This is the formula for the grand total, and you can add anything you like to it?

 

ralphdenhaan_1-1694697379534.png

 

Select Accept as Solution and Likes are always welcome. 


Ralph den Haan, (Lazy) BIM Specialist


LinkedIn | LazyBIM Blog


 

0 Likes
Message 7 of 8

archimotto
Contributor
Contributor

Ralphdenhaan,

I have a question to ask regarding your solution.

What if i divided the areas into GFA and nonGFA portion, some of the area would appears to be 0, how could i do the similar trick to have calculated value appears on both GFA/nonGFA portion?

 

Regards, 

Leonard

0 Likes
Message 8 of 8

ct_studio
Collaborator
Collaborator

Hi,

 

I am trying to do something similar. I want to multiply the number of parking spaces by a factor to produce the allowed number of units.

I'm not sure how to use the grand total in the formula field:

ct_studio_0-1741563778667.png

 

0 Likes