Count of 0 in schedules

Count of 0 in schedules

jfjacques
Collaborator Collaborator
320 Views
3 Replies
Message 1 of 4

Count of 0 in schedules

jfjacques
Collaborator
Collaborator

I am making an AREA schedule.

Is it possible to get a COUNT of 0 to show in an area schedule?  I want my columns of roomtypes to line up.  

 

I've tried if(COUNT>0, COUNT, 0)...

 

 

 

 

0 Likes
321 Views
3 Replies
Replies (3)
Message 2 of 4

barthbradley
Consultant
Consultant

What are you ultimately trying to achieve? Obviously, Count cannot be zero, but there may be another way to get to where you want to go.  Sounds like you are after a particular Schedule Format.  Can you post a Screenshot or two showing what you have and what you want? 

0 Likes
Message 3 of 4

jfjacques
Collaborator
Collaborator

jfjacques_0-1705789509935.png

This is what I'm looking for. I can do for areas by adding a dummy area. Doesn't work with counts. I can get the 0 to show with an if condition that switches a blank for a 0, the issue is that in this case, when there's no area, there's no other column forcing a blank item in the schedule.  I'm thinking I  could create another column with a count and then use the count-1 as my value to solve it, as long as I have dummy areas, but it's not worked so far. 

0 Likes
Message 4 of 4

jfjacques
Collaborator
Collaborator

nothing eh....

0 Likes