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: 

Nested IFs cause unexpected end of expression error

3 ANTWORTEN 3
Antworten
Nachricht 1 von 4
eumanzorLAARC1
1246 Aufrufe, 3 Antworten

Nested IFs cause unexpected end of expression error

I'm trying to create a conditional if statement in an area schedule for occupancy load calculations, but I'm not sure if my syntax is correct or if the statement is flawed, because I keep getting an "Unexpected end of expression" error message, please help.

 

IF (Name="BUSINESS", Area/100, IF (Name = "MECHANICAL", Area/300, IF (Name = "MERCANTILE", Area/30, IF (Name = "STORAGE", Area/300, IF (Name = "KITCHEN", Area/200, 0))))

 

 

Tags (1)
3 ANTWORTEN 3
Nachricht 2 von 4
RDAOU
als Antwort auf: eumanzorLAARC1

@eumanzorLAARC1 

 

based on the number of nested IFs you are missing a bracket at the end.

 

However it wont work even if you get the closing brackets right, Reason: you are using TEXT as a condition in a formula that is not possible in Revit atm...it can be used only as a result

 

 

YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION


Nachricht 3 von 4
barthbradley
als Antwort auf: eumanzorLAARC1

You can't reference a Text Parameter.  You could reference an integer. For instance =If(Integer Parameter=1, "My Text", "My Other Text") 

Nachricht 4 von 4
eumanzorLAARC1
als Antwort auf: eumanzorLAARC1

Thank you guys, I think I can find a work around from there. 

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