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

  • 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."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