Formula in Label not working

[LicensedARCH]

Hi!

I am having trouble getting a label in a family to calculate a simple sum of values in other labels.

I have attached the family to see if someone can figure out what I am doing wrong.

Basically, I need the "Total Existing SF" label to reflect the sum of the values of the labels for existing structures (i.e. "Existing Residence SF", "Existing Patio SF", etc.).

Similarly, I need the "Total Proposed SF" label to reflect the sum of the values of the labels for proposed structures (i.e. "Proposed ADU", "Existing Patio SF").

Any help you can provide will be greatly appreciated.

Thanks!

[LicensedARCH]

Hi!

I am having trouble getting a label in a family to calculate a simple sum of values in other labels.

I have attached the family to see if someone can figure out what I am doing wrong.

Basically, I need the "Total Existing SF" label to reflect the sum of the values of the labels for existing structures (i.e. "Existing Residence SF", "Existing Patio SF", etc.).

Similarly, I need the "Total Proposed SF" label to reflect the sum of the values of the labels for proposed structures (i.e. "Proposed ADU", "Existing Patio SF").

Any help you can provide will be greatly appreciated.

Thanks!

[barthbradley]

---

@ToanDN wrote:

How is it not?

---

I'm asking you how your approach is any different from what the OP is doing now.  The OP has all those Labels in his Compliance Analysis - each placed separately where they need to be on the sheet.   What's the benefit of placing them in another Family and nesting that Family into the Compliance Analysis?  I'm not seeing one.  What am I missing?  

[barthbradley]

---

@ToanDN wrote:

How is it not?

---

I'm asking you how your approach is any different from what the OP is doing now.  The OP has all those Labels in his Compliance Analysis - each placed separately where they need to be on the sheet.   What's the benefit of placing them in another Family and nesting that Family into the Compliance Analysis?  I'm not seeing one.  What am I missing?  

[ToanDN]

---

@barthbradley wrote:

I'm asking you how your approach is any different from what the OP is doing now.  The OP has all those Labels in his Compliance Analysis - each placed separately where they need to be on the sheet.   What's the benefit of placing them in another Family and nesting that Family into the Compliance Analysis?  I'm not seeing one.  What am I missing?  

---

I never did mention nesting.

[ToanDN]

---

@barthbradley wrote:

I'm asking you how your approach is any different from what the OP is doing now.  The OP has all those Labels in his Compliance Analysis - each placed separately where they need to be on the sheet.   What's the benefit of placing them in another Family and nesting that Family into the Compliance Analysis?  I'm not seeing one.  What am I missing?  

---

I never did mention nesting.

[barthbradley]

---

@ToanDN wrote:

---

---

I never did mention nesting.

---

So, load and place the Family on the Compliance Analysis Sheet in a Project.

Thanks for that clarification, but what's the benefit? I'm not seeing it.  I'm actually testing it as we speak. If you don't care to share, then no biggie.  I can make that determination on my own. 

Thanks again for playing.  😉  

[barthbradley]

---

@ToanDN wrote:

---

---

I never did mention nesting.

---

So, load and place the Family on the Compliance Analysis Sheet in a Project.

Thanks for that clarification, but what's the benefit? I'm not seeing it.  I'm actually testing it as we speak. If you don't care to share, then no biggie.  I can make that determination on my own. 

Thanks again for playing.  😉  

[ToanDN · Accepted solution]

The benefits are it works right off the bat with out any shared parameters in the family nor the project.  I did use the shared parameters in the family because I didn't want to retype the parameter names, but it is not necessary.

[ToanDN · Accepted solution]

The benefits are it works right off the bat with out any shared parameters in the family nor the project.  I did use the shared parameters in the family because I didn't want to retype the parameter names, but it is not necessary.

[barthbradley]

Okay then, if that's the direction OP wants to go, then I would just re-categorize the existing Compliance Analysis to Generic Annotation and put Labels in that one. 

[barthbradley]

Okay then, if that's the direction OP wants to go, then I would just re-categorize the existing Compliance Analysis to Generic Annotation and put Labels in that one. 

[LicensedARCH]

What you say makes complete sense - I just cannot figure out how to get the "EX SUM" nor the "PROP SUM" to  display on the project!

I see the "?" box but cannot find the "SUMs" - not in Shared Parameters, not in Project Parameters.

Way lost...

[LicensedARCH]

What you say makes complete sense - I just cannot figure out how to get the "EX SUM" nor the "PROP SUM" to  display on the project!

I see the "?" box but cannot find the "SUMs" - not in Shared Parameters, not in Project Parameters.

Way lost...

[barthbradley]

Miguel,

It depends on which method you are using.  

If you are using the method that you originally posted about - where the Compliance Analysis is a Title Block Family to be inserted into a Sheet, then you need to create a Project Parameters for each one of the Shared Parameters that is used by a Label in your Compliance Analysis.  Those Project Parameters are assigned the Category "Sheets".  Once they are all created, go to a Sheet and enter values for all the Project Parameters.   

If you are using the alternative method; the one where the Compliance Analysis is re-categorized as a Generic Annotation Family, then Edit the Type Properties of the Compliance Analysis Generic Annotation Family in the Project. 

Again, as I explained before, neither approach requires the "Total Existing SF" or "Total Proposed SF" Shared Parameter.   

[barthbradley]

Miguel,

It depends on which method you are using.  

If you are using the method that you originally posted about - where the Compliance Analysis is a Title Block Family to be inserted into a Sheet, then you need to create a Project Parameters for each one of the Shared Parameters that is used by a Label in your Compliance Analysis.  Those Project Parameters are assigned the Category "Sheets".  Once they are all created, go to a Sheet and enter values for all the Project Parameters.   

If you are using the alternative method; the one where the Compliance Analysis is re-categorized as a Generic Annotation Family, then Edit the Type Properties of the Compliance Analysis Generic Annotation Family in the Project. 

Again, as I explained before, neither approach requires the "Total Existing SF" or "Total Proposed SF" Shared Parameter.   

[barthbradley]

You know, you could create a Sheet List to manage the data of multiple Compliance Analyses placed on multiple Sheets in the Project - AND, in that Sheet List, you could have "Total Existing SF" and "Total Proposed SF" as CALCULATED PARAMETERS. 

 

[barthbradley]

You know, you could create a Sheet List to manage the data of multiple Compliance Analyses placed on multiple Sheets in the Project - AND, in that Sheet List, you could have "Total Existing SF" and "Total Proposed SF" as CALCULATED PARAMETERS. 

 

[LicensedARCH]

Might need to try that - or something else.
I thought this sheet family with project parameters would make it easy to use shared parameters so I don’t repeat information on schedules but I may not have a choice…

[LicensedARCH]

Might need to try that - or something else.
I thought this sheet family with project parameters would make it easy to use shared parameters so I don’t repeat information on schedules but I may not have a choice…

[LicensedARCH]

Got it.
I’ll give my original approach a try.
More convoluted but seems to not need repeating information in different places.

[LicensedARCH]

Got it.
I’ll give my original approach a try.
More convoluted but seems to not need repeating information in different places.

[barthbradley]

Use the Generic Annotation approach then. The Compliance Analysis as a Family TYPE.  

[barthbradley]

Use the Generic Annotation approach then. The Compliance Analysis as a Family TYPE.  

[LicensedARCH]

One more stupid question:
The shared parameter makes so, if I type the project name, number, APN,
client name anywhere (any sheet or sheet family), it is displaye or updated
in ALL other instances.
*Will the generic annotation family allow this as well?*
I can figure out a way to do a schedule to do calculations or even do the
math and type in an entry in its place (and not need to have it calculated
by a formula).
I am interested in inputting once and not having to update many places.
Hope that makes sense...

[LicensedARCH]

One more stupid question:
The shared parameter makes so, if I type the project name, number, APN,
client name anywhere (any sheet or sheet family), it is displaye or updated
in ALL other instances.
*Will the generic annotation family allow this as well?*
I can figure out a way to do a schedule to do calculations or even do the
math and type in an entry in its place (and not need to have it calculated
by a formula).
I am interested in inputting once and not having to update many places.
Hope that makes sense...

[barthbradley]

Both methods will work for this.  If the Compliance Analysis is a Titleblock Family, then you can manage this sort of change through a Sheet List.  

If the Compliance Analysis is a Generic Annotation Family, then a change to the Type Properties of the Type will affect ALL Instances of that Type in the Project. 

[barthbradley]

Both methods will work for this.  If the Compliance Analysis is a Titleblock Family, then you can manage this sort of change through a Sheet List.  

If the Compliance Analysis is a Generic Annotation Family, then a change to the Type Properties of the Type will affect ALL Instances of that Type in the Project. 

[barthbradley]

Let me expand on the first.  You can untick "Itemize Every Instance" to collapse the Sheet List to one row containing "varied" Sheet Number/Names. Then, in this collapsed mode, a change made to one cell's value will be applied to every Sheet.  Get it?  

[barthbradley]

Let me expand on the first.  You can untick "Itemize Every Instance" to collapse the Sheet List to one row containing "varied" Sheet Number/Names. Then, in this collapsed mode, a change made to one cell's value will be applied to every Sheet.  Get it?  

[barthbradley]

Just FWIW: you do realize that this is predominately a User's Forum; right? I'm a User like you - not an employee of Autodesk. I'm spending time helping you primarily because we're neighbors, so to speak.  I actually have friends that live in Bakersfield. I'm up in Northern California. 

[barthbradley]

Just FWIW: you do realize that this is predominately a User's Forum; right? I'm a User like you - not an employee of Autodesk. I'm spending time helping you primarily because we're neighbors, so to speak.  I actually have friends that live in Bakersfield. I'm up in Northern California. 

[LicensedARCH]

I am aware…
I keep asking questions simply because I need expert advice, not because I think you’re getting paid to respond.
I am NOT a Revit specialist so a lot of the discussion goes over my head.
My approach is to ask how Revit can do what I have in mind and not worry about how the “sausage is made” but sometimes you kinda need to know to understand the capabilities and limitations.
I do appreciate the help!
Who are your friends in Bakersfield?
I know most architects here…

[LicensedARCH]

I am aware…
I keep asking questions simply because I need expert advice, not because I think you’re getting paid to respond.
I am NOT a Revit specialist so a lot of the discussion goes over my head.
My approach is to ask how Revit can do what I have in mind and not worry about how the “sausage is made” but sometimes you kinda need to know to understand the capabilities and limitations.
I do appreciate the help!
Who are your friends in Bakersfield?
I know most architects here…