8.7.54 Duration Detail in Consolidated Currency

Table 8-33 Duration Detail in Consolidated Currency

Report Name(s) Duration Detail Product Wise in Base Currency Duration Detail Product Wise Cons Currency
Description The report displays Duration results for detailed products.
Dashboards Prompts

Prompt Market Value 1

  • Process
  • Scenario

Prompt Market Value

  • As of Date
  • Currency
  • Start Date Index
  • Product Type
Report Criteria

Calendar - ALM Results."As-of-Date"

Product."Account Type"

Product."Product Name Level19"

Master Results.Duration R

Currency."Base Currency",CASE WHEN (Product."Account Type" IN (100, 200)) THEN 'Duration (Assets)' ELSE CASE WHEN (Product."Account Type" IN (300, 400)) THEN 'Duration (Liabilities)' ELSE CASE WHEN (Product."Account Type" IN (110) OR (Product."Account Type" IN (800) AND ("Master Results"."Leg Type"=2 ))) THEN 'Duration (Off B/s Receivable)' ELSE CASE WHEN (Product."Account Type" IN (310) OR (Product."Account Type" IN (800) AND ("Master Results"."Leg Type"=1))) THEN 'Duration (Off B/s Payable)' END END END END

Conditions Product."Account Type" IN (100.00, 200.00, 110.00, 310.00, 300.00, 400.00, 800.00),"Master Results"."Start Date Index" = @{MKT1}{1}
Compound Layout

Title (2)

Pivot Table