8.7.50 Market Value Detail in Consolidated Currency
Table 8-31 Market Value Detail in Consolidated Currency
Report Name(s) |
Market Value Detail Product Wise Market Value Detail Product Wise Cons Currency |
Description | Report displays market value 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."Market Value" CASE WHEN (Product."Account Type" IN (100, 200)) THEN 'Market Value (Assets)' ELSE CASE WHEN (Product."Account Type" IN (300, 400)) THEN 'Market Value (Liabilities)' ELSE CASE WHEN (Product."Account Type" IN (110) OR (Product."Account Type" IN (800) AND ("Master Results"."Leg Type"=2 ))) THEN 'Market Value (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 'Market Value (Off B/s Payable)' END END END END , "Currency"."Base Currency" |
Conditions | Product."Account Type" IN (100.00, 200.00, 300.00, 400.00, 800.00, 110.00, 310.00),"Master Results"."Start Date Index" = @{MKT1}{1} |
Compound Layout |
Title (2) Pivot Table |