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

Note:

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