8.7.16 Forecast Balance Sheet Detail in Consolidated Currency

Table 8-8 Forecast Balance Sheet Detail in Consolidated Currency

Report Name(s)	Forecast Balance Sheet Detail in Base Currency Forecast Balance Sheet Detail in Consolidated Currency
Description	Forecast Balance Sheet across time buckets, with Product level detail and option to choose Avg + End, Avg Only or End Only.
Dashboards Prompts	Prompt Financial Results 01 Prompt Financial Results 02 Prompt Financial Results 03
Report Criteria	Product < formula >: case WHEN "Product"."Account Type" IN(100.00, 200.00) then 'Total Assets' WHEN "Product"."Account Type" IN (300, 400.00, 500.00) then 'Total Liabilities' end Time Buckets.Start Date Time Buckets.End Date Product.Product Name Level18 Standard Cash Flow Results.Ending Balance (100) Currency.Base Currency
Conditions	Product.Account Type in (100,200,300,400,500)
Compound Layout	Title View Selector Pivot Table - Average and Ending Balance Pivot Table2 - Average Balance Pivot Table3 - Ending Balance