# Thread: Calculating Values in a schedule with Text parameters

1. Login to Give a bone

## Calculating Values in a schedule with Text parameters

I am trying to combine (2) text fields using a calculated value in my schedule. The two text fields are "Type Comments" and "Mark". We use these for tagging our equipment and would like to export the combined field to Excel.

Is this possible? Thanks in advance.

2. Login to Give a bone

## Re: Calculating Values in a schedule with Text parameters

I would seriously doubt you can "calculate" between two text values. I would guess that the fields would at least have to be "number" or "integer" type.

3. Login to Give a bone

## Re: Calculating Values in a schedule with Text parameters

You can not directly combine text strings. An interesting work around is that you can use a little math to display what you are looking for. By setting an integer value a text string can use a formula to check for a series of numbers with a nested IF statement.

The formula I used is:
if(integer = 1, "Show text string 1", if(integer = 2, "Show text string 2", "ERROR"))

If you wanted additional notes you can keep adding to the nested IF statement.
Hope this helps.

4. Login to Give a bone

## Re: Calculating Values in a schedule with Text parameters

Originally Posted by archjake
You can not directly combine text strings. An interesting work around is that you can use a little math to display what you are looking for. By setting an integer value a text string can use a formula to check for a series of numbers with a nested IF statement.

The formula I used is:
if(integer = 1, "Show text string 1", if(integer = 2, "Show text string 2", "ERROR"))

If you wanted additional notes you can keep adding to the nested IF statement.
Hope this helps.
Very Slick!!!

5. Login to Give a bone

## Re: Calculating Values in a schedule with Text parameters

Hello,

You can also add both parameters (because they are system params) to the label as shown here:

http://screencast.com/t/LGhOZ9cDFQ

Cheers,
Glynnis Patterson

6. Login to Give a bone

## Re: Calculating Values in a schedule with Text parameters

Originally Posted by glynnis.patterson
Hello,

You can also add both parameters (because they are system params) to the label as shown here:

http://screencast.com/t/LGhOZ9cDFQ

Cheers,
Glynnis Patterson
Glynnis,
That example is for creating tags. The original question was for combining text strings in a schedule.

7. Login to Give a bone

## Re: Calculating Values in a schedule with Text parameters

Folks, I actually do this all the time for special reporting needs and instances when I need more descriptive color code plan legends or descriptive report data. I create a "placeholder" parameter to receive the joined text, then I coincidentally use Glynnis's "BIMLink" tool to export my data out to excel format. Open in MS Access and manipulate the multiple text fields into whatever format/joining desirable. Re-import into Revit via BIMLink. The downside is the data is not dynamic and requires repeating these steps. But it only takes a couple of minutes which is negligible when I really need the customization to the legends or reports.

Coincidentally I also use the method described by Archjake (formula/variables) when there is a need for the data to behave dynamically in a true "BIM" fashion. I will admit this is the best way to go when time permits, the data is changing a lot, and there is a repetitive need.

Hope this helps.

8. Login to Give a bone

## Re: Calculating Values in a schedule with Text parameters

Hey guys,
I'm trying to use an if/then statement in a door schedule using the Type Mark as the driver for the new parameter. No matter what it always returns the "Improper use of Boolean Expression" error. Is there anything special about using Type Mark in an if statement that might cause this? I know I've got my syntax right. I'd really appreciate some feedback if anyone knows what the issue is. Thanks!

2013-07-08_1005.png

9. Login to Give a bone

## Re: Calculating Values in a schedule with Text parameters

Originally Posted by haney8604551873
Hey guys,
I'm trying to use an if/then statement in a door schedule using the Type Mark as the driver for the new parameter. No matter what it always returns the "Improper use of Boolean Expression" error. Is there anything special about using Type Mark in an if statement that might cause this? I know I've got my syntax right. I'd really appreciate some feedback if anyone knows what the issue is. Thanks!

2013-07-08_1005.png
Revit does not allow Text Parameters or strings to be used in conditional statements, so you cannot even use "Type Mark = Type Mark" as a conditional statement.

10. Login to Give a bone

## Re: Calculating Values in a schedule with Text parameters

You Can combine 2 text fileds using dynamo (which add 2 parameter values in a 3rd parameter and this 3rd parameter is the one which is filtered by in the schedule then you can create a tag family by this 3rd parameter.

you can find attached image showing dynamo for this issue.Dynamo1.jpg

#### Posting Permissions

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