Hello,
I need to add a new value equal to sum of two other value in a door schedule.
More precisely, i have a window schedule sorted by door typemark.
As two door types A and B are similar (mirrored) i need to add their counts (No. of types A+B).
For the other doors (like C, D, E, F) no need to add their count.
Thank you, Dan
Sorting and Grouping is the only way we can aggregate data together to provide a count, within Revit schedules natively. Creating alternative summaries of data could be done externally (export to Excel and reassemble in Revit) via 3rd party tools.
If you provide another parameter to sort by, such as "InCommon", you could check the box for "InCommon" for both A + B doors and not the others. Then you could sort the doors/windows by that parameter instead.
Often I find such subtle requirements can be resolved differently. For example, a simple note above the schedule could warn the reader that A + B doors are similar and can be counted together. I admit I don't understand the motivation to do this though. Another approach is to use two schedules, filter for only doors/windows <"C" so A+B doors appear together and then a second schedule for the rest filter for >"B". Two schedules tell the story.
Steve Stafford
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.