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.
Gelöst! Gehe zur Lösung
Gelöst von robert.klempau. Gehe zur Lösung
Gelöst von robert.klempau. Gehe zur Lösung
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.
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
Thanks for your replies.
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.
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.
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.
And finaly the product on the layout.
Greetings.
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.
Add the Key parameter to your Raumliste.
See the Revit project in the attachment.
Hope this is your perfect solution. ![]()
Hello @schlueter and @ToanDN,
Then I would add the Department parameter to the Key Schedule and use that in the Tag family.
Now I think I solved all the problems ![]()
See the Revit Project in the Attachment.
Hello @ToanDN,
Thanks ![]()
You helped me think in the right direction.
Hope @schlueter feels the same way.![]()
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". ![]()
Greetings
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.