topic Re: Formula integer in Revit Architecture Forum

Formula integer

kboschJGDNZ — Thu, 27 Sep 2018 14:25:43 GMT

Hello

I want the following formula to work with integers:

IF(condition=true,show parameter, show nothing)

This however only works when I fill a number at the last part. (show nothing = 0 or some other number)

"Show nothing" with a text parameter is just "", but with integers this doesn't work

Does anyone know a way to make this work?

Re: Formula integer

L.Maas — Thu, 27 Sep 2018 15:13:15 GMT

While for a string "" is still a string. For integers you will need an integer value. So unfortunately you can not make this work. There have been ideas to be able to reset a parameter back to null (not assigned), but this is not implemented (yet?).

Re: Formula integer

kboschJGDNZ — Thu, 27 Sep 2018 16:01:32 GMT

Ok that's a pitty then. Hopefully this will be implemented some day.

Re: Formula integer

ToanDN — Thu, 27 Sep 2018 16:07:38 GMT

You would wish there is something like what you can do in Excel, would you not? Alas...

Re: Formula integer

kboschJGDNZ — Thu, 27 Sep 2018 16:26:25 GMT

Now I think about it...you can suppress trailings...I wonder if you can supress a single zero. I'll check this out when I'm at work.