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.
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?!
Gelöst! Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
Itemize and make sure no cells are Blank. All Blanks must be filled with 0. After that, you can unitemize and it should work.
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!
@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.
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.