# Thread: Zero suppression in door numbers

1. Login to Give a bone

## Zero suppression in door numbers

I know I have seen this before, but I can not find out where to change it right now. I have a room # that is 001. The Room tags are displaying correctly, but the door tags are not. Our door tags are set up to read the room number. Where do I find the setting that controls this for the door tags?

2. Login to Give a bone

## Re: Zero suppression in door numbers

I've narrowed down the problem. For door numbers, we reference the room # and we have a manual definition for a suffix. Then we combine these two with a formula to produce the door number. The number appears correctly (001) in the room # category but once the formula adds the suffix, that is where the 00 is lost. Is there a fix for this situation? Is it because it's a formula?

3. Login to Give a bone

## Re: Zero suppression in door numbers

The forumla I have always used simply shows the room number and suffix side by side.

However, I have never had your problem because we always begin room numbering at 101.

4. Login to Give a bone

## Re: Zero suppression in door numbers

What does your formula property look like?

What sort of suffix are you adding?

I do not have time to test this right now, but something like this, where all values are converted to strings, should work, provided that you can live with a string as the result of the formula property

"[roomnumberproperty]" & "[suffixproperty]"

5. Login to Give a bone

## Re: Zero suppression in door numbers

David, shouldn't the door number actually be the room number?

6. Login to Give a bone

## Re: Zero suppression in door numbers

Yes, it should. Thanks for pointing that out. I fixed it in my original post.

7. Login to Give a bone

## Re: Zero suppression in door numbers

Our RoomNumber is a location property def. and the Suffix is a manual prop. def. Using a formula to combine them produced: [RoomNumber][NumberSuffix]

In the Style Manager, the RoomNumber category reads the number correctly from the space, it's just in the formula category where it drops the two 00's.

I'm not sure I'm following what you mean by converting them to strings.

Our suffix's are usually "a", "b" ect if there are multiple doors in the room. This particular door does not have a suffix as it's the only door in the basement. I think if I try to delete the suffix for this one door tag, it would reek havoc on my schedule, wouldn't it? there are other doors in the project that are using suffix's.

8. Login to Give a bone

## Re: Zero suppression in door numbers

Originally Posted by sharla
Our RoomNumber is a location property def. and the Suffix is a manual prop. def. Using a formula to combine them produced: [RoomNumber][NumberSuffix]

In the Style Manager, the RoomNumber category reads the number correctly from the space, it's just in the formula category where it drops the two 00's.

I'm not sure I'm following what you mean by converting them to strings.

Our suffix's are usually "a", "b" ect if there are multiple doors in the room. This particular door does not have a suffix as it's the only door in the basement. I think if I try to delete the suffix for this one door tag, it would reek havoc on my schedule, wouldn't it? there are other doors in the project that are using suffix's.
Your formula uses implied concatenation, which does not always give the desired results, as in this case. Use explicit concatenation, with the property references enclosed in pairs of double quotation marks. My generic example
"[roomnumberproperty]" & "[suffixproperty]"
would be
"[RoomNumber]" & "[NumberSuffix]"

9. Login to Give a bone

## Re: Zero suppression in door numbers

Beautiful! Thank you! That works perfectly.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•