What To Do if the Metrics Won't Export to Excel or Excel is Erroring When Trying to Open an Exported File.
If errors are occurring when exporting metrics to Excel or when an exported Excel file is opened, it is most likely caused by invalid formats. The formats in Connections Online are more relaxed than that of Excel. Even though the metric values may be displaying correctly in Connections Online, Excel may error on export or open. One of the biggest mistakes in formatting comes from using words in the formats such as "#,##0 days". This format will work in Connections but will not work in Excel. To properly format it, include double quotations around "days" so that the format becomes #,##0 "days".
User Defined Numeric Format Examples
Some sample format expressions for numbers are shown below. (These examples all assume that a system’s local setting is English-U.S.) The first column contains the format strings. The other columns contain the output that results if the formatted data has the value given in the column headings (minimum, meets, exceeds and trend data). A User can choose the format string that will represent the format for the metric to show (type it into the format field on the metric edit page if it is not available by default).
Format ( if typing the following format string, the columns to the right will show the results) |
If 5 typed: (positive # in minimum, meets, exceeds fields) |
If -5 typed: (negative # in minimum, meets, exceeds fields) |
If .5 typed: (Decimal # in minimum, meets, exceeds fields) |
Zero-length string |
5 |
-5 |
0.5 |
0 |
5 |
-5 |
1 |
0.00 |
5.00 |
-5.00 |
0.50 |
#,##0 |
5 |
-5 |
1 |
#,##0.00;;;Nil |
5.00 |
-5.00 |
0.50 |
$#,##0; ($#,##0) |
$5 |
($5) |
$1 |
$#,##0.00; ($#,##0.00) |
$5.00 |
($5.00) |
$0.50 |
0% |
500% |
-500% |
50% |
0.00% |
500.00% |
-500.00% |
50.00% |
Examples of Common bank Measures and Formats:
Common Credit Union Measures |
Formatting Examples |
Numeric Data to be Displayed |
How Number Displays on Org/Dept Tab |
ROA |
#.####% |
.0097 |
.97% |
Percentages |
#.####% |
.85 |
85% |
Dollars |
$#,### |
4500 |
$4,500 |
Examples of using Text in the Formats
Formats containing words must have the words enclosed in quotations. If not done properly, the wording can cause unexpected errors, including failure to export to Excel.
Worded Format |
Formatting Examples |
Numeric Data to be Displayed |
How Number Displays in Connections |
Hours |
#,##0 "HRS" |
50 |
50 HRS |
Minutes |
#:## "Min" |
150 |
1:50 Min |
Days |
#,##0 "Days" |
1100 |
1,100 Days |
Million |
$#,##0 "Million" |
554 |
$554 Million |
Please sign in to leave a comment.
Comments
0 comments