Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Calculated Value Conundrum

4 ANTWORTEN 4
GELÖST
Antworten
Nachricht 1 von 5
emodderman
330 Aufrufe, 4 Antworten

Calculated Value Conundrum

Hello!

 

I have a schedule with a calculated value that returns no value! I can't figure out why... I've checked out other solutions here and they have not worked yet... 

 

I have a schedule with many parts of a curtain panel family scheduled. I need the total cost of the Panel, based on the sum of the individual part costs. The part costs are also a calculated value, and this value works fine. What I am trying to do that is returning the 0 value is add up the sum of the PART COST (LENGTH) column and the PART COST (AREA) columns. 

 

emodderman_0-1652295489055.png

PART COST (LENGTH) formula:

COST PER * ((PART LENGTH / 304.8) / 1 mm)

PART COST (AREA) formula:
COST PER * ((INFILL AREA * 10.7) / 1 m²)

 

Total Cost formula:

[PART COST (LENGTH)] + [PART COST (AREA)]

OR I have also tried:

(COST PER * ((PART LENGTH / 304.8) / 1 mm)) + (COST PER * ((INFILL AREA * 10.7) / 1 m²))

the second formula makes the requirement of the individual part cost per area or length columns obsolete, but it still returns an empty cell or a $0.00 value. 

This also brings me to another weird thing... 

When I UNCHECK Itemize Every Instance, I get a $0.00 value, but when I CHECK the Itemize Every Instance, I get a blank cell. 

All my values are currency, formatting should be correct, I'm totally all the columns I can think of, but even when I don't, nothing changes. 

I cannot upload this file, there is too much information to share here... 
Is there a reason you can think of that would prevent the Total Cost column from displaying a value?!

 

 

4 ANTWORTEN 4
Nachricht 2 von 5
ToanDN
als Antwort auf: emodderman

Itemize and make sure no cells are Blank.  All Blanks must be filled with 0.  After that, you can unitemize and it should work.

Nachricht 3 von 5
emodderman
als Antwort auf: ToanDN

Hm. There is no way I can get all blank cells to display 0. Some of the parts do not have a Part Length or Infill Area parameter... It's one or the other.

I guess I'm not going to make this happen! But it's good to know the rules here.

Thank you!

Nachricht 4 von 5
ToanDN
als Antwort auf: emodderman


@emodderman wrote:

Hm. There is no way I can get all blank cells to display 0. Some of the parts do not have a Part Length or Infill Area parameter... It's one or the other.

I guess I'm not going to make this happen! But it's good to know the rules here.

Thank you!


Edit [PART LENGTH] material in the schedule and tick Add to all elements...  repeat for other parameters that need to be in the formula.  Then you should be able to fill 0 to blank cells.

 

ToanDN_0-1652307285914.png

 

 

Nachricht 5 von 5
emodderman
als Antwort auf: emodderman

but the parameter is inside each component part... so will just adding the parameter as a project parameter work for the ones that don't have it already? I think I will end up with two columns instead... 

It's quite a complex family with lots of connected parameters and nested, shared families, so basically I have to weigh the advantages of being able to get a total in the schedule against adding unnecessary parameters to all my components... 
project is on hold for now, but I will try it out... 

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report