Percent of Total column
This display-only spreadsheet column shows the percentage of the total for the spreadsheet row.
To calculate the percent of total:
-
If any addon columns are included in the layout, Sage Estimating (SQL) divides the Grand Total Amount (which includes allocated addons) by the estimate total.
-
If no addon columns are in the layout, Sage Estimating divides the Total Amount (which excludes allocated addons) by the estimate total.
If an amount changes in the spreadsheet row, Sage Estimating (SQL) recalculates the percentage.
Note: Addon columns include Addon Amount, Grand Total Price, and Grand Total Amount.