The formula doesn't work

[ArmanMargaryan]

Hello!

The formula doesn't work. It is possible to enter two identical parameters in the formula so that the second parameter does not understand text.

if(or(z Offset Value < -0' 4", z Offset Value > -0' 4"), [z Offset Value], "")

[ArmanMargaryan]

Hello!

The formula doesn't work. It is possible to enter two identical parameters in the formula so that the second parameter does not understand text.

if(or(z Offset Value < -0' 4", z Offset Value > -0' 4"), [z Offset Value], "")

[martijn_pater]

Both [z offset value] and "" need to be text (the latter is...) to return text to the text parameter, so I suspect z offset value is not a text parameter...edit: actually it is, since it's in the condition for the if statement so there's your answer... 

PS. are we talking about scheduling or family formula...?

[martijn_pater]

Both [z offset value] and "" need to be text (the latter is...) to return text to the text parameter, so I suspect z offset value is not a text parameter...edit: actually it is, since it's in the condition for the if statement so there's your answer... 

PS. are we talking about scheduling or family formula...?

[ArmanMargaryan]

Revit formula need to understand what is written in parentheses [] is a parameter, not a text.

PS. We are talking about Family formula.

Sorry, if I could not explain the problem well.

Thanks.

[ArmanMargaryan]

Revit formula need to understand what is written in parentheses [] is a parameter, not a text.

PS. We are talking about Family formula.

Sorry, if I could not explain the problem well.

Thanks.

[syman2000]

Can you post the family or screenshot to see what we are looking at? In some cases family parameter if it is tied to dimension will not allow negative value.

[syman2000]

Can you post the family or screenshot to see what we are looking at? In some cases family parameter if it is tied to dimension will not allow negative value.

[ToanDN]

You are having two types of output, one is Length and one is Text. That does not work. Are you just trying to omit the output when the value is -4"?

[ToanDN]

You are having two types of output, one is Length and one is Text. That does not work. Are you just trying to omit the output when the value is -4"?

[barthbradley]

this?

[barthbradley]

this?

[martijn_pater]

---

@martijn_pater wrote:

is=isn't*, a text parameter for z value.

---

You can't convert number to text, unless you have a finite number of possibilities maybe. See attached.

[martijn_pater]

---

@martijn_pater wrote:

is=isn't*, a text parameter for z value.

---

You can't convert number to text, unless you have a finite number of possibilities maybe. See attached.

[Ilic.Andrej]

---

@ArmanMargaryan wrote:

if(or(z Offset Value < -0' 4", z Offset Value > -0' 4"), [z Offset Value], "")

---

It looks like you are complicating things for some reasons only you know of. Have you heard the phrases: "Less is more.", and "Simple is hard"?

[Ilic.Andrej]

---

@ArmanMargaryan wrote:

if(or(z Offset Value < -0' 4", z Offset Value > -0' 4"), [z Offset Value], "")

---

It looks like you are complicating things for some reasons only you know of. Have you heard the phrases: "Less is more.", and "Simple is hard"?

[ArmanMargaryan]

Unfortunately, they are not limited to me.

[ArmanMargaryan]

Unfortunately, they are not limited to me.

[ArmanMargaryan]

it's a beam tag. This is in the Label:

[ArmanMargaryan]

it's a beam tag. This is in the Label:

[ArmanMargaryan]

This is how it works when I do Load into Project. That's wrong, it's supposed to be the value of "z Offset Value".

[ArmanMargaryan]

This is how it works when I do Load into Project. That's wrong, it's supposed to be the value of "z Offset Value".

[martijn_pater]

Use a prefix (and/or suffix) in the tag label with your z value parameter.

Label parameter prefix

[martijn_pater]

Use a prefix (and/or suffix) in the tag label with your z value parameter.

Label parameter prefix

[ArmanMargaryan]

This parameter should be set for beams that are -0 '- 4 "low or high. 

As shown in the picture, but instead of the text "z Offset Value" write the value of the "z Offset Value"

[ArmanMargaryan]

This parameter should be set for beams that are -0 '- 4 "low or high. 

As shown in the picture, but instead of the text "z Offset Value" write the value of the "z Offset Value"

[barthbradley]

---

@ArmanMargaryan wrote:

it's a beam tag. This is in the Label:

---

I don't understand what you are pointing out to me.  That's exactly the formula I showed you above.  Looks like it worked.  No?  

[barthbradley]

---

@ArmanMargaryan wrote:

it's a beam tag. This is in the Label:

---

I don't understand what you are pointing out to me.  That's exactly the formula I showed you above.  Looks like it worked.  No?  

[ArmanMargaryan]

I tried it before you wrote it.

[ArmanMargaryan]

I tried it before you wrote it.

[martijn_pater]

Like I said, it's not possible to convert number to text. Just use prefix/suffix with the parameter for the tag's label... 

[martijn_pater]

Like I said, it's not possible to convert number to text. Just use prefix/suffix with the parameter for the tag's label...