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?!
