8.9.2.7 Funding Center Original Vs. Remaining

Table 8-102 Funding Center Original Vs. Remaining

Report Name	TP Funding Center Org Vs Rem
Description	This report allows users to compare Remaining Term and Original Term transfer pricing results.
Dashboards Prompts	Prompt - AsOfDate (FundingCenter) As of Date Prompt - Product (Funding Center) Product Name Prompt - OrgUnit (Funding Center) Org Unit Name Prompt - Product Type Product Type
Report Criteria	"Dim Product"."Product Name Level19" Dim Product.Product Name Product < formula > sum(CASE WHEN "Fact Ledger Stat"."Financial Element Identifier" = 140 THEN "Fact Ledger Stat"."Value" END) Product < formula > sum(case when "Fact Ledger Stat"."Financial Element Identifier" = 170 then "Fact Ledger Stat"."Value" end) Product < formula > sum(case when "Fact Ledger Stat"."Financial Element Identifier" = 450 then "Fact Ledger Stat"."Value" end) Product < formula > sum(case when "Fact Ledger Stat"."Financial Element Identifier" = 172 then "Fact Ledger Stat"."Value" end) Product < formula > sum(case when "Fact Ledger Stat"."Financial Element Identifier" = 452 then "Fact Ledger Stat"."Value" end) Product < formula > sum(IFNULL((case when "Fact Ledger Stat"."Financial Element Identifier" = 170 then "Fact Ledger Stat"."Value" end), 0) - IFNULL((case when "Fact Ledger Stat"."Financial Element Identifier" = 172 then "Fact Ledger Stat"."Value" end),0)) Product < formula > sum(IFNULL((case when "Fact Ledger Stat"."Financial Element Identifier" = 450 then "Fact Ledger Stat"."Value" end),0) - IFNULL((case when "Fact Ledger Stat"."Financial Element Identifier" = 452 then "Fact Ledger Stat"."Value" end),0))
Conditions	Fact Ledger Stat."Financial Element Identifier" IN (140, 170, 450, 172, 452),"Dim Product"."Account Type" IN (100, 200, 300, 400)
Compound Layout	Title Table (2)
Report Name(s)	TP Funding Center Org Vs Rem