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: 

Revit Schedule with multiple totals

6 ANTWORTEN 6
GELÖST
Antworten
Nachricht 1 von 7
JML_Mela
421 Aufrufe, 6 Antworten

Revit Schedule with multiple totals

Hello all!

 

It is possible to do a schedule similar to the following one?

With subtotals and totals in columns?

mela_0-1652262540281.png

Thank you!

 

 

6 ANTWORTEN 6
Nachricht 2 von 7
ToanDN
als Antwort auf: JML_Mela

Yes. By adding a calculated value parameter for each subtotal column. Share a sample model then I can show you.

Nachricht 3 von 7
JML_Mela
als Antwort auf: ToanDN

Hi! @ToanDN 

 

I have linked a file with an example, you will see that there is an schedule that already have the parameter  JML_Location.

 

In Excel, the formula would be something like:

 

Column PR 01  

   =if(PR_Location="PR 01", count,"-")

Column PR 02  

   =if(PR_Location="PR 02", count,"-")

Column PR 03  

   =if(PR_Location="PR 03", count,"-")

Column Total

    Count

 

Thank you!

 

 

Nachricht 4 von 7
barthbradley
als Antwort auf: JML_Mela

You can use nested IF statements in a Calculated Parameter. See "IF AND OR Returning the greatest of three values".

 

https://www.revitforum.org/node/1126

 

 

Also note that Conditional statements can only evaluate numeric values, numeric parameter names, and Yes/No parameters.  Not Text.  

 

About Calculated Parameters:

 

https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2020/ENU/Revit-M...

 

Nachricht 5 von 7
ToanDN
als Antwort auf: JML_Mela

See Revit 2019 file (I do not have 2018), it should explain itself.  If you cannot open it then I can explain with some screenshots.

 

ToanDN_0-1652283180744.png

 

Nachricht 6 von 7
JML_Mela
als Antwort auf: ToanDN

THANK YOU!!!!!

 

I got it! 

First intent I couldn't because i didn't activate the calculation in the format, second, it went GREAT!!!

 

If I would know I would create my shared parameter as integer.

 

I don't get to understand this integers very well.

 

mela_0-1652348777542.png

 

Best regards!!!!!

Nachricht 7 von 7
JML_Mela
als Antwort auf: barthbradley

Thank you very much for the info.

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