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
Prompt Market Value
|
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 |