Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Combine Calculated Value

21 ANTWORTEN 21
Antworten
Nachricht 1 von 22
Anonymous
3338 Aufrufe, 21 Antworten

Combine Calculated Value

Hi ya'll,

 

I want to combine two Calculated Value, but since they're not parameters, it's not available from the list. Is this possible?

 

Regards,

Derek

21 ANTWORTEN 21
Nachricht 2 von 22
barthbradley
als Antwort auf: Anonymous

Because combined parameters are not assigned to a category, they cannot be reused. If you want to use the combined parameter in another schedule, you must redefine it.

 

 

https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2017/EN...

 

Nachricht 3 von 22
syman2000
als Antwort auf: Anonymous

You can get it to work. I did a test creating dummy calculated value X & Y. When I create the Z calculated value, I am able to reference X & Y calculated value to give me another calculated value.

 

shared value.png

 

Z value.png

Check out my Revit youtube channel - https://www.youtube.com/user/scourdx
Nachricht 4 von 22
barthbradley
als Antwort auf: syman2000

Combine Parameters

Nachricht 5 von 22
syman2000
als Antwort auf: barthbradley

All you need to do is create calculated value with X in between the X, Y, Z value. Then you use the cell and hide the lines in between.

calc.png

Once that is done, remove the header and you will get one seemless combine calculated value.

combine shared.png

Check out my Revit youtube channel - https://www.youtube.com/user/scourdx
Nachricht 6 von 22
Anonymous
als Antwort auf: barthbradley

Hi @barthbradley,

 

"Because combined parameters are not assigned to a category, they cannot be reused." -okay, noted.

 

"If you want to use the combined parameter in another schedule, you must redefine it." -I am able to combine Parameters the way I need them to appear, with prefixes, suffixes, dashes and dots and such. I am also able to create Calculated Value with formulas base on what need to be presented in the format I need.

 

Thanks for sharing the link anyway.

Nachricht 7 von 22
ToanDN
als Antwort auf: Anonymous

Can you show an example of the final combined parameter that you want?
Nachricht 8 von 22
barthbradley
als Antwort auf: Anonymous

My understanding was that you wanted to Combine Calculated Parameters. If you are able to do that through Combine Parameters, please share. 

Nachricht 9 von 22
Anonymous
als Antwort auf: barthbradley

@barthbradley 

 

I was thinking to use a formula to populate my Calculated Value this way:

If (Product, "CalculatedValue 1", "Calculated Value 2")

Nachricht 10 von 22
ToanDN
als Antwort auf: Anonymous


@Anonymous wrote:

@barthbradley 

 

I was thinking to use a formula to populate my Calculated Value this way:

If (Product, "CalculatedValue 1", "Calculated Value 2")


What are the parameter types of Product, CalculatedValue 1, and CalculatedValue 2?

Nachricht 11 von 22
Anonymous
als Antwort auf: syman2000

@syman2000 

this method won't work for my case since I'm trying to do a either-or condition where I'm trying to base on a Yes/No param. But this might work on future Schedule. Neat trick, thanks for sharing!

Nachricht 12 von 22
Anonymous
als Antwort auf: ToanDN

@ToanDN 

What are the parameter types of

 

[Product] is [IP-Yes/No]

[CalculatedValue 1] is a Combined Param consist of [IP-text]-[IP-text]-[IP-text]-[IP-text]

[CalculatedValue 2] is [IP-text] #this is essentially the param that contains the room#

...where IP is Instance Parameter.

 

I have another thought on doing this but also am unsure on is that... is it possible to transpose the CV1 into a new param and grab this param from the Calculated Value formula Fields?

Nachricht 13 von 22
barthbradley
als Antwort auf: Anonymous

Still trying to wrap my brain around this. So, what you are saying is that you want to create a Calculated Parameter with the formula =if (Product, "Calculated Value 1", "Calculated Value 2") - where "Product" is a Yes/No Parameter, "Calculated Value 1" is a Combined Parameter of Text Parameter Values, and "Calculated Value 2" is Calculated Parameter of the Text Type that is "essentially the param that contains the room".  

 

Based on your description, I'm envisioning something like this. See why I can't wrap my brain around this? 

 

C1.pngC2.pngC3.png

 

 

Nachricht 14 von 22
Anonymous
als Antwort auf: barthbradley

@barthbradley

Combined Parameters aren't a Shared Parameter therefore I can't call it out from the Formula, and so my thought of transposing that outcome into a parameter that'd be great.

Nachricht 15 von 22
Anonymous
als Antwort auf: syman2000

Hi, 

I'm trying to follow your steps to create an 'x' column in a schedule. Is the Area Metric also a calculated value?

Nachricht 16 von 22
barthbradley
als Antwort auf: Anonymous

Border1.png

Nachricht 17 von 22
Anonymous
als Antwort auf: barthbradley

Hi,

My question is how to populate a column with an 'x' so I can effectively combine two calculated values in a schedule.

 

 

Nachricht 18 von 22
barthbradley
als Antwort auf: Anonymous


@Anonymous wrote:

Hi,

My question is how to populate a column with an 'x' so I can effectively combine two calculated values in a schedule.

 

 


 

I don't understand what you are trying to do. Provide some examples. Pictures would help too.  

Nachricht 19 von 22
Anonymous
als Antwort auf: barthbradley

Hi,

I'm trying to do what syman20000 shows in Message 3 of this thread from 5-24-2019.

Nachricht 20 von 22
barthbradley
als Antwort auf: Anonymous

All he is doing is removing the linework between columns X, A, Y, B, Z with the Edit Border tool I showed you a screenshot of. There's nothing fanciful happening.  No calculations are being made. 1, X, 2, X ,2  are cell values with no border line between them.   

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report