topic Re: Boolean Statement w/ Text, Erroring in Revit MEP Forum

Boolean Statement w/ Text, Erroring

jessem5CN9L — Thu, 25 Jul 2024 13:53:11 GMT

Hi all, been scratching my head on this. Given the parameters below:

What I want is that when DO_Card Reader says "CR", only Red will be checked. And when DO_Card Reader says anything else, only Blue will be checked.

I've used the statement if([DO_Card Reader]="CR", 1=1, 1=0) and other variations, but I keep getting an "Improper use of boolean expressions" error.

A different statement that has no text like "CR" works just fine.

What formula can I put in here to make it work properly?

Re: Boolean Statement w/ Text, Erroring

djthompson — Fri, 26 Jul 2024 10:33:46 GMT

As incredible as it may seam you cannot do any Boolean operations with text in Revit.

Re: Boolean Statement w/ Text, Erroring

tim.ingle — Mon, 29 Jul 2024 14:07:12 GMT

Hi @jessem5CN9L, like @djthompson mentioned, text cannot be referenced in formulas unless it is to display a specific result in a Text parameter. A way you could get around this, would be to use another YesNo parameter to toggle the Card Reader / "CR" reference. Depending on how many values you need for the DO_Card Reader parameter, you could just duplicate this formulaic system as much as you need.

Also, in order to control YesNo parameters through formulas, they have an assumed result, where if the condition in the formula is not met, then the parameter will be equal to No (and vise versa). I've included an example of these formulas.

Re: Boolean Statement w/ Text, Erroring

mikewp90 — Mon, 29 Jul 2024 15:55:21 GMT

One way is to utilize use of lookuptables which can be expanded for more complex iterations.