By Autodesk Revit default, the total is different from the sum because the total is calculated using the exact value of the areas and not the rounded values shown in the schedule.
If you would like the total to be based on the rounded values instead, follow these steps:
- In the Instance Properties palette, click the Edit button for Fields.
- In the Schedule Properties dialog box, click the Calculated Value button.
- In the Calculated Value dialog box, enter a name (for example, "AreaRoundInteger").
- Change the Type to Integer.
- Enter the following formula: Area / 1 * 100
Note: Dividing by 1 prevents unit errors.
Note: The factor depends of the decimal places that are used. In this example, 100 is used for 2 decimal places. - Click OK to close the Calculated Value dialog box.
- Click the Calculated Value button again.
- In the Calculated Value dialog box, enter a name "AreaRound".
- Change the Type to Number.
- Enter the following formula: AreaRoundInteger / 100
- Click OK to close the Calculated Value dialog box.
- Select the Residential_Area (for this example) field and then click the Edit button
- Revise to the following formula: if(Residential, AreaRound *1, 0)
- In the Schedule Properties dialog box, click the Formatting tab.
- Select the AreaRoundInteger field and AreaRound field, and then click the Hidden Field option.
- Select the Residential field and then click the Calculate Totals option.
- Click the Field Format button and set the rounding to 2 decimal places.
- Click OK to close each dialog box. You will get the correct result as below:-
3 comments:
Thanks Ko Min Thu.
Very Useful tip
By Autodesk Revit default, the total is different from the sum because the total is calculated using the exact value of the areas and not the rounded values shown in the schedule.
custom tailoring services , stitching unit , best online tailor , sewing factory , sewing of ladies suits , sewing expert , sewing factory near me
By Autodesk Revit default, the total is different from the sum because the total is calculated using the exact value of the areas and not the rounded values shown in the schedule. lawn cotton suits , pakistani lawn suits for sale , pakistani lawn suits online shopping , lawn suits online , pakistani lawn suits price , pakistani lawn dress , pakistani cotton suits , designer lawn suits online , pakistani lawn suits wholesale , lawn suits sale
Post a Comment