Schedule 'Calculated Value' Formula (Numbers & Text)

[Chad Smith]

This is something that should be easy to do, but I can't get it to work.

I want to put a Calculated Value into my schedule and want the formula to be in the order of;


IF (NUMBER > 0 , NUMBER, "N/A")
The Calculated Value is of Type 'Text'.

Is it possible to simply convert the number to text?

[Elmo]

Text parameter just do not work witht the other parameters in a nice way. I would just rather use integar,length or number to achieve what you want.

[SkiSouth]

How about IF (NUMBER>0,NUMBER, TEXT) where TEXT is predefined as "N/A". Just guessing - didn't try it..

[Chad Smith]

The TEXT part isn't the problem. The parameter is defined as TEXT, but the NUMBER won't convert to text. It would seem as though TEXT and NUMBERS cannot exist in the same formula at all.

It's been quite a while since I've done any form of programming, but it was common practice (and I'm sure still is) to be able to use a function to do this. Something like;

Str ( NUMBER )

[dbaldacchino]

I'd like to have exactly what you're trying to achieve, but as far as I know, that's not possible in Revit. Too bad.

[GuyR]

The easiest way to do this currently is use type catalogues. Generate them in a spreadsheet using formulae to give you the mixed number/text values.

HTH,

Guy

[Chad Smith]

I need it to calculate it at the Schedule level in case new family Types are created within the project.
I guess the field could always be entered in manually, but I was hoping to use the 'intelligence' of Revit to avoid conflicting info.

For the meantime I have settled on using '0' as the result.

[archjake]

I need it to calculate it at the Schedule level in case new family Types are created within the project.
I guess the field could always be entered in manually, but I was hoping to use the 'intelligence' of Revit to avoid conflicting info.

For the meantime I have settled on using '0' as the result.

you could hide the calculated value and set another parameter to look at that parameter and perhaps display a yes or a no.

[Chad Smith]

A Yes/No answer isn't enough for what I need. I need the formulas answer to be either the number value or "N/A"