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 Values in scheduele

11 ANTWORTEN 11
Antworten
Nachricht 1 von 12
Anonymous
540 Aufrufe, 11 Antworten

Calculated Values in scheduele

Hello,

I have a problem with a calculated value which I can't seem to figure out how to solve. As you can see from the image I get 0% under collum M (Grad av utnyttelse).

 

Schema.png

11 ANTWORTEN 11
Nachricht 2 von 12
barthbradley
als Antwort auf: Anonymous

There's a null value in "Areal Tomy".

 

plus: 1/0*100=0, so 0 is correct

Nachricht 3 von 12
L.Maas
als Antwort auf: barthbradley

1/0*100 = 0 ? hmmmm Smiley (fröhlich)

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

Nachricht 4 von 12
Anonymous
als Antwort auf: Anonymous

Your formula seems to just want the percent of a column. If so, choose 'Percentage' instead of 'Formula' and Revit will do that calculation for you. You can then select which parameter to get percent, and what total to divide it into.

Nachricht 5 von 12
barthbradley
als Antwort auf: L.Maas

What @L.Maas?  Do you disagree with my math? 

 

 

Nachricht 6 von 12
David_Knight
als Antwort auf: barthbradley

I took it that technically the answer to  1 divided by 0 = "undefined" and Not "0".

 

but that's really splitting hairs.

your answer was fine in my book.

 

 

Nachricht 7 von 12
L.Maas
als Antwort auf: barthbradley

Sorry, just my nerdiness kicking in.

Louis

EESignature

Please mention Revit version, especially when uploading Revit files.

Nachricht 8 von 12
ToanDN
als Antwort auf: Anonymous

Why column K blank? Not Calculate Total?

You can try Percentage instead of Formula.
Nachricht 9 von 12
barthbradley
als Antwort auf: ToanDN


@ToanDN wrote:
Why column K blank? Not Calculate Total?

You can try Percentage instead of Formula.

Actually, the point I'm making is that there are no values whatsoever in the "Blank" column. They are all NULL, so the calculation is:  "Areal/NULL*100".  What the heck would this return? Still, even if the NULL value is computed as zero, any real number multiplied by zero is zero.  

Nachricht 10 von 12
Anonymous
als Antwort auf: barthbradley

Hello,

Thanks for all your answers. Maybe the problem wasn't clear in the first picture. I've tried to change the formatting in collum K but that doesn't help. I like to have percent in collum M but that isn't critical.

 

Thanks again!

 

 

2018-09-28_08-31-47.png

Nachricht 11 von 12
barthbradley
als Antwort auf: Anonymous

Percent.png

Nachricht 12 von 12
Anonymous
als Antwort auf: Anonymous

The thing you should remember is that the bottom row is a Grand Total, and each group has a subtotal. You can't get the program to just do the calculation on the last row. It will do the calculation for each row, and then the Grand Total will add them all together. So make sure under formatting for Column M you select 'Calculate Totals.' If that doesn't work, there still may be some hang up will the null values talked about in the discussion before. Dividing by null could nullify the Column M values above which could nullify the Column M totals.

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