In SAS^® Financial Management reports, you can eliminate decimal places so that numbers display as rounded integers.

For example, if you have the following series in your report:

3.4, 3.4, 3.4

using Excel formatting to eliminate the decimal places that are displayed will effectively 'display' rounded integers:

3, 3, 3

but there is no actual change to the data values. That is, the report calculates the sum as 10 (3.4 + 3.4 + 3.4 = 10.2, but with no decimals displayed).

You can also choose to have the results rounded. For example, entering the formula

=ROUND((B3+C3+D3),1)

in cell E3 (which is actually an Excel-based calculated member) displays a rounded total of 10.0, even though the actual value is still 10.2.

However, if you want the report to calculate the sum of the rounded integers, open Microsoft Excel and select:

• For Excel 2003: Tools > Options > Calculation > Precision as Displayed


• For Excel 2007: Select the Office button then 'Excel Options' and then 'Advanced'. Under the heading 'When calculating this workbook', select 'Set Precision as Displayed'


• For Excel 2010: Select File > Options, then select 'Advanced'. Under the heading 'When calculating this workbook', select 'Set Precision as Displayed'

The report will then calculate the sum as 9.0 (3 + 3 + 3). Please be aware that this not only changes how the values are displayed, as with the rounding above. It impacts the total data value.

You also have the ability within SAS Financial Management to apply rounding to any calculations you define for members in your dimensions. Since reporting formulas and modeling formulas are calculated at query time and are not stored in the SAS Financial Management database, the rounded value is not stored, but the actual value of the original calculation is. The formula below is the equivalent of the above Excel-based formula that rounds the sum of (Oct 2009 + Nov 2009 + Dec 2009), to 1 decimal place and displays a total of 10.0.

For more information on eliminating decimal places and applying styles in SAS Financial Management reports, please refer to SAS Note 30520.

For more information on Excel-based calculated members and applying formulas in SAS Financial Management, please refer to the SAS Financial Management Formula Guide.

Operating System and Release Information

Product Family	Product	System	SAS Release
			Reported	Fixed*
SAS System	SAS Financial Management	Windows
		Microsoft Windows 2000 Advanced Server
		Microsoft Windows 2000 Datacenter Server
		Microsoft Windows 2000 Server
		Microsoft Windows 2000 Professional
		Microsoft Windows Server 2003 Datacenter Edition
		Microsoft Windows Server 2003 Enterprise Edition
		Microsoft Windows Server 2003 Standard Edition
		Microsoft Windows XP Professional
		64-bit Enabled AIX

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

---

Setting rounded numbers in a report to accumulate to the total of the rounded numbers, not to the total of the actual numbers.

Type:	Usage Note
Priority:

Date Modified:	2011-03-23 13:12:37
Date Created:	2007-12-06 15:59:21