In Autodesk Revit, creating cumulative quantities in a schedule involves using calculated values and formulas. Here's a step-by-step guide on how to achieve this:
1. Create a New Schedule:
- Open your Revit project.
- Go to the View tab and click on Schedules.
- Choose Schedule/Quantities.
2. Select Categories and Fields:
- In the Schedule Properties dialog, select the category for which you want to create the cumulative quantities.
- Add the fields you want to include in the schedule, such as "Quantity."
3. Add a Calculated Value for Cumulative Quantity:
- Click on the Calculated Value field in the Fields tab of the Schedule Properties.
- In the Edit Calculated Value dialog, click the "Add" button.
- Name the calculated value, e.g., "Cumulative Quantity."
4. Write the Formula for Cumulative Quantity:
- In the Formula section of the Edit Calculated Value dialog, use the following formula:
```excel
Cumulative Quantity = Previous(Cumulative Quantity) + Quantity
```
This formula adds the current quantity to the previous cumulative quantity.
5. Format the Schedule:
- Adjust the formatting of the schedule to make it clear that it represents cumulative quantities.
- You may want to adjust column headers, add labels, or format the Cumulative Quantity column to distinguish it.
6. Sort the Schedule:
- To ensure the cumulative values display correctly, you may need to sort the schedule by a specific parameter (e.g., by a date or a unique identifier).
7. Adjust Grouping and Sorting:
- Group and sort the schedule based on your project requirements. This can help organize and present the cumulative quantities in a meaningful way.
8. Apply the Schedule:
- Click OK to apply the changes and close the Schedule Properties dialog.
- Place the schedule on a sheet or view it in your project.
Now, your schedule should display cumulative quantities based on the formula you defined. Remember that this approach assumes you have a logical order for your items (e.g., chronological order) to make the cumulative calculations meaningful. Adjust the formula and sorting criteria accordingly based on your project requirements.