Grand Totals inside Calculated Formula

[zakim]

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.

[ralphdenhaan]

Hi,

See print screen:

ralphdenhaan_0-1694691660263.png

[zakim]

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

[ralphdenhaan]

Something like this?

ralphdenhaan_0-1694695197001.png

[zakim]

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

[ralphdenhaan · Accepted solution]

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

ralphdenhaan_1-1694697379534.png

[archimotto]

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

[ct_studio]

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