Usage Note 30707: How to have rounded numbers accumulate as displayed
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
| 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.
| Date Modified: | 2011-03-23 13:12:37 |
| Date Created: | 2007-12-06 15:59:21 |
