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

 

 


© 2020 AIR Worldwide. All rights reserved.

Touchstone 6.0 Updated September 03, 2020