topic Re: How to hide value 0 in schedule in Revit Architecture Forum

How to hide value 0 in schedule

Anonymous — Mon, 04 Jun 2018 03:20:06 GMT

Hi everyone,

I want to show the below schedule as below but without number 0 in the SQ field.

I try to search all over, but have no idea how to made it.

I also try to convert number to text for an IF statement, but also can't find any formula to change number to text.

Could you please help me,

Thanks a lot,

Re: How to hide value 0 in schedule

zemeraloni — Mon, 04 Jun 2018 03:41:45 GMT

Hi @Anonymous

you can use filter to set that only area above 1sf will be visable, see attached image.

Re: How to hide value 0 in schedule

Anonymous — Mon, 04 Jun 2018 03:52:30 GMT

Thanks for response, but if I do that, the POS area can not show on the Schedule.

I want to show all Area, but without number 0, because it look nonsense in a schedule 🙂

Actually, I just want to show Blank on SQ column for POS area,

Re: How to hide value 0 in schedule

zemeraloni — Mon, 04 Jun 2018 04:25:21 GMT

Well then i don't know how to do that sorry..

You can do thing like the image below but i'm not sure if it's looks better

Re: How to hide value 0 in schedule

Anonymous — Mon, 04 Jun 2018 04:33:21 GMT

@zemeraloni: Thanks for your help. I hope that could be ok, but it is not. Anyway, I'm very thank you for your very quick response.

Re: How to hide value 0 in schedule

Ilic.Andrej — Mon, 04 Jun 2018 10:40:33 GMT

Take a look at this concept. Click on the images to enlarge.

Re: How to hide value 0 in schedule

Anonymous — Mon, 04 Jun 2018 12:05:10 GMT

@Ilic.Andrej: That's very impressive. Thank you so much. But I still can't have total in New Area. 😞

I think it is really close to the perfect solution.

Could you have another light for me?

Thank you again and again for your time.

Re: How to hide value 0 in schedule

Ilic.Andrej — Mon, 04 Jun 2018 14:56:24 GMT

@Anonymous wrote:
@Ilic.Andrej: That's very impressive. Thank you so much. But I still can't have total in New Area. 😞

I think it is really close to the perfect solution.

Could you have another light for me?

Thank you again and again for your time.

Sadly, I think it can't be done. This is the best I can do:

Re: How to hide value 0 in schedule

ToanDN — Mon, 04 Jun 2018 21:41:05 GMT

Where did the SQ values come from?

Re: How to hide value 0 in schedule

Anonymous — Mon, 04 Jun 2018 22:19:27 GMT

Thank you so much. You do the best, mate.

Re: How to hide value 0 in schedule

Anonymous — Mon, 04 Jun 2018 22:26:20 GMT

@ToanDN: SQ is a calculate parameter take value from Area and a Y/N parameter to get the construction area SQ=IF(Built,Area/9.29m2,Null)

I tried to use Null value, but when use the calculate total on Formatting, the number 0 is appeared again.

Re: How to hide value 0 in schedule

ToanDN — Mon, 04 Jun 2018 22:52:15 GMT

If you want to keep them in one schedule then you need to accept the 0 subtotals (right pic). or you could split it into several schedules and set some to not calculate total (left pic).

Re: How to hide value 0 in schedule

Anonymous — Mon, 04 Jun 2018 23:11:29 GMT

@ToanDN Thank you. That is the solution I tried before, but actually, I prefer how to combine all schedule in one than split them. Because I will face to multi unit projects, and must create a lot of schedule like that.

But, have somethings better than nothing 🙂

Re: How to hide value 0 in schedule

ToanDN — Mon, 04 Jun 2018 23:20:19 GMT

I would keep it as one schedule too. I don't think nobody is going to complain about the 0 subtotals. If they do, create a white text type and use it to mask the subtotals.

Re: How to hide value 0 in schedule

opferjohn — Mon, 22 Jul 2019 18:34:52 GMT

What is Area Null Value?

Re: How to hide value 0 in schedule

Anonymous — Mon, 22 Jul 2019 23:25:30 GMT

@opferjohn It still has 0.00 in total. I reckon that is always give a value for a calculate parameter.

Re: How to hide value 0 in schedule

nkovach — Thu, 06 Feb 2020 18:52:25 GMT

This rocks! Thank you for contributing to this discussion.. I would never have thought to pull from these null values.. genius!

Re: How to hide value 0 in schedule

seanUFNGF — Sat, 13 Feb 2021 00:14:37 GMT

I found this awesome, simple solution and if worked like a charm!

https://www.revit.news/2019/08/hide-zero-values-in-revit-schedules/

Re: How to hide value 0 in schedule

Davidminkov_work — Sat, 21 Dec 2024 04:41:51 GMT

You are the boss