Revit Schedule with multiple totals

[JML_Mela]

Hello all!

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

With subtotals and totals in columns?

Thank you!

[ToanDN]

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

[JML_Mela]

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!

[barthbradley]

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...

[ToanDN · Accepted solution]

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.

[JML_Mela]

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.

Best regards!!!!!

[JML_Mela]

Thank you very much for the info.