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: 

If formula in schedules

11 ANTWORTEN 11
GELÖST
Antworten
Nachricht 1 von 12
schlueter
3349 Aufrufe, 11 Antworten

If formula in schedules

Hi,

 

i have a problem with a formula in my room-schedule and i hope you can help me.

 

Parameters:

Name = obviusly the name of the room

Ebene = Floor

vag_räume_kategorie = VKFL (Sales area) or NNFL (Storage area)

Calculated Value "VKFL" = at the moment (Area / 1 m²) * 1

Calculated Value "NNFL" = at the moment (Area / 1 m²) * 1

Fläche = Area

 

What do i want?

I'm trying to create a formula in the Calculated values for "VKFL" and "NNFL" that looks at the parameter "vag_räume_kategorie" and if its "VKFL" it takes the area value and if not its just 0. The same for "NNFL".

 

So i tried something like if(vag_räume_kateforie=VKFL , area , 0) in different variantions with "", calculated value (area) and (number).

 

But the result is alwasy an error! So my skill lvl is to low for "if" conditions and i really need your help.

 

Here is a picture of what we try to get but at the moment its all handmade and i also attached a file with the schedule.

 

Thanks for your help and i hope you understand what i'm trying to do.

2017-01-09_14h52_09.jpg

 

 

----------------------------------------------------------------------------------------------------------------------
Falls es dein Problem gelöst hat, kannst du auch gerne auf den Button "Als Lösung akzeptieren" klicken.
11 ANTWORTEN 11
Nachricht 2 von 12
ToanDN
als Antwort auf: schlueter

Conditional statements can contain numeric values, numeric parameter names, and Yes/No parameters.  Your "vag_räume_kategorie" is a text parameter so it does not work.

 

Do you need to show the value of "vag_räume_kategorie" in any Tags?  If not, you can get away without using a shared parameter, then there is a possibility to make it work.

Nachricht 3 von 12
ToanDN
als Antwort auf: schlueter

Something like this:

 

Capture.PNG

Nachricht 4 von 12
robert.klempau
als Antwort auf: schlueter

Hallo @schlueter,

 

Ich habe noch ein Alternative für Sie gemacht.

Ich hoffe das Sie so weiterkönnen.

Bitte schauen sie sich den Anhang an.

 

I have made another alternative for you

I hope this is what you want.

I used the Integer to select the vag_räume_kategorie.

Based on the number the VKFL and NNFL is calculated and also the Fläche.

There are several hidden fields in the schedule.

Please see the attachment

 

Raumliste.png

 

If my post answers your question, please click the "Accept as Solution" button. This helps everyone find answers more quickly!

Kind regards,
Robert Klempau
Senior Consultant AEC
Cadac Group AEC BV

Nachricht 5 von 12
schlueter
als Antwort auf: robert.klempau

Thanks for your replies.

 

@ToanDN

 

It would be so easy with a text parameter. But ok i think a have another post for the idea forum.

 

Do you need to show the value of "vag_räume_kategorie" in any Tags?  If not, you can get away without using a shared parameter, then there is a possibility to make it work.

 

Yes. We read that parameter in the roomtag.

 

I like the idea with the with the yes/no parameter. Would be cool if i could link the "vag_räume_kategorie" in the Roomtag with the yes/no parameter from the schedule. But that wont work either.

 

Even if its +1 parameter to rklempau's idea i think the checkboxes are a good way and easier to unterstand if you don't know the schedule. So i decided to stick with it and some dynamoscript for the problem with the text parameter.

 

 

@robert.klempau

In german and english. Thanks :).

Its another good way and you have less parameter but everyone needs to now what 1 or 2 means. Like i mentioned befor i think the yes/no is easier to understand.

 

 

So thats the current schedule withe some extra parameter we use. So dont be confused.

2017-01-10_13h44_52.jpg

 

 

And this is my dynamoscript for the schedule. It checks for VKFL or NNFL in the Textparameter and set the yes/no parameters to true or false.

 

2017-01-10_13h54_37.jpg

 

 

And finaly the product on the layout.

 

2017-01-10_14h04_27.jpg

 

Greetings.

 

----------------------------------------------------------------------------------------------------------------------
Falls es dein Problem gelöst hat, kannst du auch gerne auf den Button "Als Lösung akzeptieren" klicken.
Nachricht 6 von 12
ToanDN
als Antwort auf: schlueter

Good use of Dynamo.

In Revit 2017 you will be able to use Calculated parameters in Tags and that may solve the problem.
Nachricht 7 von 12
robert.klempau
als Antwort auf: schlueter

Hello @schlueter,

 

You could use a room key schedule for the vag_räume_kategorie.

 

you don't need the dynamo script then.

 

Create a Room Key Schedule with the vag_räume_kategorie_nummer parameter as the second column. Add three rows an fill in the Key Names.

 

vag_räume_kategorie key schedule.png

 

Add the Key parameter to your Raumliste.

vag_räume_kategorie.png

 

 

See the Revit project in the attachment.

 

Hope this is your perfect solution. Smiley (zwinkernd)

 

If my post answers your question, please click the "Accept as Solution" button. This helps everyone find answers more quickly!

Kind regards,
Robert Klempau
Senior Consultant AEC
Cadac Group AEC BV

Nachricht 8 von 12
ToanDN
als Antwort auf: robert.klempau

The only problem is a Key Name from a Key Schedule cannot be in a Tag.
Nachricht 9 von 12
robert.klempau
als Antwort auf: ToanDN

Hello @schlueter and @ToanDN,

 

Then I would add the Department parameter to the Key Schedule and use that in the Tag family.

 

vag_räume_kategorie key schedule 2.png

 

Now I think I solved all the problems Smiley (fröhlich)

 

 

See the Revit Project in the Attachment.

 

 

If my post answers your question, please click the "Accept as Solution" button. This helps everyone find answers more quickly!

Kind regards,
Robert Klempau
Senior Consultant AEC
Cadac Group AEC BV

Nachricht 10 von 12
ToanDN
als Antwort auf: robert.klempau

Very brilliant!
Nachricht 11 von 12
robert.klempau
als Antwort auf: ToanDN

Hello @ToanDN,

 

Thanks Smiley (überglücklich)

 

You helped me think in the right direction.

 

Hope @schlueter feels the same way.Smiley (zwinkernd)

If my post answers your question, please click the "Accept as Solution" button. This helps everyone find answers more quickly!

Kind regards,
Robert Klempau
Senior Consultant AEC
Cadac Group AEC BV

Nachricht 12 von 12
schlueter
als Antwort auf: robert.klempau

@robert.klempau

 

Thanks alot.

 

Didn't use key schedules befor but after some reading i know them a little better.

 

Your Solution is very nice. Would be absolutly perfect if i don't have to use the department parameter but thats based on the limits of revit. Guess i have another thread for the idea forum "global parameters in key schedules". :zwinkerndes_Gesicht:

 

Greetings

----------------------------------------------------------------------------------------------------------------------
Falls es dein Problem gelöst hat, kannst du auch gerne auf den Button "Als Lösung akzeptieren" klicken.

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