Schedule Formula for Fittings Cost

[stevej]

Hi All

I have only recently started using Revit MEP and had a Love/Hate relationship to start with but now we are warming to each other. 

Could anyone help me out with Schedule formulas, i'm trying to build some cost schedules and i have a pipe cost formula that works fine but im struggling with a formula for pipe fittings.  For some reason the formula i am using will not read the pipe fitting Size details, it seems to be related to the ( - xx mmø ) element.

Any help with the attached formula or other ideas for fitting costing would be most appreciated.

Thanks Steve Fitting Schedule Formula

[PavelAnd]

Hi @stevej . I think you cannot use "Size" parameter in a formula because its storage type is "String". To use a parameter in a formula, you need a number ("Integer" or "Double"). See if there is a suitable parameter in your family and if not, add it.

[stevej]

Thanks for your advise Pavel.

The problem i have with adding a parameter is it needs to correspond to the size of the fitting and as this differs when you connect a pipe to the fitting i cant think of a parameter to use that will change when the fitting size changes.  Any ideas?

Reagrds Steve

[PavelAnd · Accepted solution]

If you open the mechanical template and create a standard fitting, then you will see that it has the parameters nominal radius and nominal diameter. But they are not available in the schedule. Add a general parameter and equate it with the formula in the family to the radius parameter (I equated to the radius, for the diameter in the formula you need to add "*2"). Next, create a schedule, add the created general parameter and create a parameter with formula for the price. Examples in the attachment (R2019).

[stevej]

Hi Pavel

Thanks heaps for that it has fixed the issue i was having, also really good to have the GIF video made it easy to follow your instructions.

Your a star 

Regards Steve