Currency Columns in Loss to CSV Reports
When you export a loss that includes exposure information to a CSV report you might be dealing with two types of currency—the currency in your exposure data and the currency used in the loss analysis. Therefore, some exported CSV reports include two currency columns: Exposure Currency and Analysis Currency. Loss to CSV reports that include both currency columns are:
-
Exposure and AAL by Contract
-
Exposure and AAL by Geography
-
Exposure and AAL by Location
Exposure and ALL by LOB reports include only the Analysis Currency column.
Depending on how you configured the loss analysis, the Exposure Currency column might be blank; this is by design. For more information on configuring loss analysis output options, see Specifying Output Options.
The following table shows the combinations of output options that display no data in the Exposure Currency columns. All affected reports are Exposure and AAL by Geography reports, although not all Geography reports are affected.
Loss Analysis Output Option Combinations that Produce Blank Exposure Currency Columns in Exposure and AAL by Geography Reports
Loss Outputs |
Geography |
Contract Summary |
Location Summary |
---|---|---|---|
Portfolio |
Country |
||
Portfolio |
Country |
Yes |
|
Portfolio |
Area |
||
Portfolio |
Area |
Yes |
|
Portfolio |
Area |
Yes (Disabled) |
Yes |
Portfolio |
Sub Area |
||
Portfolio |
Sub Area |
Yes |
|
Portfolio |
Postcode |
||
Portfolio |
Postcode |
Yes (Disabled) |
Yes |
Contract |
Country |
Yes (Disabled) |
|
Contract |
Country |
Yes (Disabled) |
Yes |
Contract |
Area |
Yes (Disabled) |
|
Contract |
Area |
Yes (Disabled) |
Yes |
Contract |
Sub Area |
Yes (Disabled) |
Yes |
Contract |
Postcode |
Yes (Disabled) |
|
Layer |
Country |
||
Layer |
Country |
Yes |
|
Layer |
Country |
Yes (Disabled) |
Yes |
Layer |
Area |
||
Layer |
Area |
Yes |
|
Layer |
Area |
Yes (Disabled) |
Yes |
Layer |
Sub Area |
||
Layer |
Sub Area |
Yes |
|
Layer |
Sub Area |
Yes (Disabled) |
Yes |
Layer |
Postcode |
||
Layer |
Postcode |
Yes |
|
Layer |
Postcode |
Yes (Disabled) |
Yes |
LOB |
Event Total |
Yes (Disabled) |
Yes |
LOB |
Country |
Yes |
|
LOB |
Country |
Yes (Disabled) |
Yes |
LOB |
Area |
||
LOB |
Area |
Yes |
|
LOB |
Area |
Yes (Disabled) |
Yes |
LOB |
Sub Area |
||
LOB |
Sub Area |
Yes |
|
LOB |
Sub Area |
Yes (Disabled) |
Yes |
LOB |
Postcode |
||
LOB |
Postcode |
Yes |
|
LOB |
Postcode |
Yes (Disabled) |
Yes |