How to Add a Total Cost Category Summary to a DESTINI Cloud: Estimator Report

The Cloud Cost Category Report (also known as the Cloud LMSEO Report) provides a detailed cost category breakdown for each line item. You can summarize cost category details on the Executive Summary page by adding a Totals column, as described in this article.

This article describes how to add a Labor Total Cost column to the Base Estimate Level 1 Summary. You can repeat this procedure to add additional cost category totals to the report.

1. Open an estimate in DESTINI Cloud: Estimator.
2. Navigate to Home > New Report. Report Designer opens.
3. Click File > Open.
4. Navigate to the folder with the report template file (.repx) you want to modify.
5. Click the file .repx file to open it.
6. In the Designer in the middle of your screen, locate the column headers for your Base Estimate Level 1 Summary.
7. Right-click the Description column header and select Insert > Cell, as shown in the following screenshot.
   
8. Report Designer inserts the new cell to the right of the Description cell.
9. With the new cell selected, click the Gear button and set Text as Labor Total, as shown in the following screenshot.
10. Right-click the [WBSProperty1] cell below the Description column header and select Insert > Cell, as shown in the following screenshot.
    
11. With the new cell selected, click the Gear button. Inside the context menu, specify the following. Set the Summary property first, otherwise the expression generates an error.
    • Summary = Group
    • Format String = {0:c0}
    • Expression = Iif(sumSum([TotalLaborCost]) = 0, '', sumSum([TotalLaborCost]))
      
12. Using the Ctrl key, multi-select both new cells.
13. Locate the Properties panel on the bottom right side of your screen.
14. Set the Text Alignment to right justified and adjust the cell width based on your preference, as shown in the following screenshot. If you can't see these options, widen your Properties panel.
    
15. If you'd like to add additional cost categories to your report, repeat this procedure. Specify the following expressions for each cost category. When you're finished, save and run the report.