How to use Length parameter in a formula?

[Anonymous]

Hi all

I have a simple but tricky problem here.

My curtain mullion has a length of 2730, but I want to report it in schedule as 2709, since I need to have different values for other mullions I (maybe) cannot use formulas in schedule (because it would affect also other cells).

Therefore I thought I could create a formula in the Curtain mullion parameter that uses "Length", but it seems is not possible.

Suggestions? Maybe use Global parameter (tried but same result)?

error

[barthbradley]

Why not a Calculated Parameter directly placed in the Schedule.  "Length-12". Or, it could be an IF Statement that evaluates a particular wall parameter, and returns "Length-12" or "Length".  (e.g. "if(Mark=ABC, Length-12, Length)").  You could even assign an On/Off Project Parameter to all the Walls, and check the Wall that should be evaluated in an IF Statement Calculated Parameter. (e.g. "if([wall is checked], Length-12, Length)").  

[Anonymous]

Hi @barthbradley, thanks for replying.

The point is that I need to assign different values to the mullions on the same column, but when I use Calculated Parameter (f.e. Length-21) it performs the same formula to alle the cells in the column.

To be specific:

sometimes I need "Length - 21"

sometimes I need "Length - 12"

and so on..

Thats why I tried to place the formula in the framily itself, but did not achieve the result.

I managed to obtain the result with a workaround placing a new parameter in the family the is dependent to the type, then Caltulating Parameter in the schedule using those two different parameters, but its a bit dirty solution to me.

Wondering if there is a cleaner way.

[ToanDN · Accepted solution]

What he suggested is the right way to do it. You need to create another parameter to drive the criteria for the formula. If a mullion has this parameter = a then the reported length = true length - x, and so on.