How to Add Cost/Unit to a Line-Item Row

By default, DESTINI Cloud reports include a Cost/Unit column in all rows except the Line-Item Details row. The Line-Item Details row prints the unit cost value not the cost/unit.

Use the following procedure to add the cost/unit value to a line-item row.

Update Parameters

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 .repx file to open it.
6. On the right side of your screen, click the Field List tab at the bottom of Report Explorer.
   
7. In the search field on the Field List tab, enter IncludedCostPerUnitSummaries. Click the search result.
   
   The Properties panel displays information about the IncludedCostPerUnitSummaries parameter.
   
8. Enter the following after the last value in the Value field (including the comma):
   ,Line Item Details
   
   
9. Expand the Value Source property and then click the ellipses (...) in the Look-Up Values field.
   
   The Look-Up Values dialog box opens.
10. Click the Add button, and then enter the following in the new row:
    Line Item Details
    
    
11. Click OK.

Add Cells to Designer

Use the following procedure to add a new Cost/Unit column to the right of the line-item Total Cost.

1. On the right side of your screen, click the Report Explorer tab.
2. In the search field, enter Details_LineItems. Select the search result to automatically select the corresponding element in Designer.
   
   
3. In Designer in the middle of your screen, scroll down to locate the selected detail report from the previous step.
   
4. Right-click the Total column header and click Insert > Column to Right. Repeat this step for each row in this section that ends with WBSProperty#.
   
5. Click the new column header beside TOTAL that you created in the previous step, and then click the Function button.
    
6. In Expression Editor, paste the following inside the text box and click OK.
   'COST/' + Upper(?CostPerUnitSummary_Unit)
   
   
7. Select the new cell in the next row down, and then click the Gear button to the right.
   
   The Cell Tasks dialog box opens.
8. Enter the following information in the specified order:
   1. Summary: Choose Group from the dropdown list.
   2. Format String: Paste {0:c2} into the field.
   3. Expression: Click the ellipses (...), delete the expression in the text box, and then paste an expression into the text box.  See Table 1: Expressions for the correct expression to enter for a given row.
      
      
9. For each new cell you created, repeat steps 7 and 8 to configure cell task properties and enter an expression. Use the following table to locate the correct expression.

Table 1: Expressions

Remove Duplicate Unit Cells in WBS Grouped Rows

In the unmodified version of the Cloud Owners Report, the WBS Property grouped rows have a Unit column to the left of the Total Cost column. After completing the previous procedure, your WBS Property grouped rows have an additional Cost/Unit column to the right of the Total Cost column that prints the same value.

Use the following procedure to delete the original Unit column in the WBS property grouped rows.

1. In Designer in the middle of your screen, select the first cell under the Unit column header at the top of the Line Items Detail Report (Details_LineItems control).
2. Right-click the cell and select Delete > Cell.
   
   Note: Don't delete the Unit cell in the section header. The column is still used for line-item unit costs.
   
3. Repeat the previous step for the next three rows. This removes the original Unit cells from the WBS Property GroupHeaders.
   
4. Skip the line-item details row (GroupHeader10).
5. Locate the Unit cell for the next grouping (WBS Property 4 GroupFooter).
   
6. Right-click the cell and select Delete > Cell.
7. Repeat the previous step for the next three rows. This removes the original Unit cells from the WBS Property GroupFooters.
   
8. Save and run your report.
   

(Optional) Formatting Cleanup

Adding a new column reduces the width of existing columns. As a result, some headers (such as Quantity) may wrap to a new line.

1. To adjust column width, select the cell in Designer and drag its left or right edge.
   
    

2. Save and run the report.

Related Articles

• How to Use the Cost Per Unit Summary
• How to Change Cost/Unit Summary Property in a Cloud Report
• How to Show All Cost/Unit Summaries in a Cloud Report
• How to Turn off Cost/Unit Summaries in a Cloud Report
• How to Add an Additional Cost Per Unit Column to a Cloud Report