How to replace zeros with empty cells or NA or -?

[Mehdi.Kardehi]

Hi All,

I am preparing a schedule of fancoils.

Revit by default put 0 for numbers that have not been entered. How could they be replaced by empty cells or something appropriate like NA or - in the schedule?

Regards,

M

[CoreyDaun]

You can force those cells to be blank if that Parameter does not exist in the element. If removing this Parameter from the Family is not an option or the Parameter in question is a Project Parameter, you are pretty much out of luck.

If revit could a Number value as a text string, it would be easy using a Calculated Value (Text) with the formula:

= if( [NumberParam] > 0, [NumberParam], "")

But alas, Revit cannot do this. 

If there are a limited number of possible values for your Number parameter, then you could use a C.V. (Text) with the formula:

= if( [NumberParam] = 1, "1", if( [NumberParam] = 2, "2", if( [NumberParam] = 3, "3", "")))

But this is impractical and downright silly.

[russellvee]

You can use conditional formatting to fill the box in black if the value is zero.

[MPanutsosU7NXZ]

How?!