8.7.52 Market Value Detail by Scenario in Consolidated Currency

Table 8-32 Market Value Detail by Scenario in Consolidated Currency

Report Name(s) Market Value of Equity - Detail Market Value of Equity Cons Currency Detail
Description Report displays market value results for a selected product with comparison across scenarios.
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."Product Name Level19"

case when "Process Scenario (Bench)"."Scenario Name"="Process

Scenario"."Scenario Name" then 1 end

Master Results."Market Value"

Master Results."Market Value (Bench)"

Master Results."Market Value (Delta To Bench)"

Master Results."Market Value (Pct To Bench)" "Currency"."Base Currency",

CASE WHEN (Product."Account Type" IN (100, 200)) THEN 'Market Value (Asset)' 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

Conditions "Product"."Account Type" IN (100, 110, 200, 300, 310, 400, 800),"Master Results"."Start Date Index" = @{MKT1}{1}
Compound Layout

Title

Pivot Table