Skip to content
  • There are no suggestions because the search field is empty.

How to Change Numerical Formatting in DESTINI Cloud Reports

Most numeric and currency values in DESTINI Cloud: Estimator reports display either zero or two decimal places. To better align with your company's branding standards, you can adjust decimal precision, as described in this article.

  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. Click a cell you want to format. The following example uses the Quantity cell for [WBSProperty1]. When you click the cell, a gear icon displays, as shown in the following screenshot.

    Click a cell in the Report Designer to display a settings gear icon.
  7. Click the gear icon. The Table Cell Tasks dialog box displays.
  8. In the Format String field, click the ellipsis (...). The Format String Editor dialog box displays.
  9. Choose a category such as Number or Percent in the Category pane.
  10. In the Standard Types pane, choose a format. The dialog box displays an example of the category format beneath the pane. 
  11. Click OK.
  12. Save and run your report.

Optionally, you can type or paste decimal place formats for number and currency fields directly into the Format String field, as shown in the following screenshot.

Manually entering a decimal place format in the Format Strings field.

The Format String field supports the following decimal point formats.

Standard Type

Full Format String

Description

n0

{0:n0}

Number with 0 decimal places

n2

{0:n2}

Number with 2 decimal places

n4

{0:n4}

Number with 4 decimal places

c0

{0:c0}

Currency with 0 decimal places

c2

{0:c2}

Currency with 2 decimal places

c4

{0:c4}

Currency with 4 decimal places