8.7.31 Net Income Distribution Min 3 or Max 3 or Avg

Table 8-20 Net Income Distribution Min 3 or Max 3 or Avg

Report Name(s)	Net_Income_25_5
Description	The report displays average earnings across all rates paths along with top 3 and bottom 3 earnings results from the simulation over forecast time buckets.
Dashboards Prompts	Prompt - EAR_002 As of Date Prompt - EAR Process Process Prompt - EAR Bucket End Date Bucket End Date
Report Criteria	"Time Buckets"."End Date" "Earnings-at-Risk"."Rate Path Num" AVG("Earnings-at-Risk"."Net Interest Income" by "Time Buckets"."End Date") Max("Earnings-at-Risk"."Net Interest Income" by"Time Buckets"."End Date") Min("Earnings-at-Risk"."Net Interest Income" by "Time Buckets"."End Date") CASE WHEN RANK("Earnings-at-Risk"."Net Interest Income" BY "Time Buckets"."End Date") = 2 THEN "Earnings-at-Risk"."Net Income" END CASE WHEN RANK("Earnings-at-Risk"."Net Interest Income" BY "Time Buckets"."End Date") = (max (RANK("Earnings-at-Risk"."Net Interest Income" BY "Time Buckets"."End Date")) -1) THEN "Earnings-at-Risk"."Net Income" END CASE WHEN RANK("Earnings-at-Risk"."Net Interest Income" BY "Time Buckets"."End Date") = 3 THEN "Earnings-at-Risk"."Net Income" END CASE WHEN RANK("Earnings-at-Risk"."Net Interest Income" BY "Time Buckets"."End Date") = (max (RANK("Earnings-at-Risk"."Net Interest Income" BY"Time Buckets"."End Date")) -1) THEN "Earnings-at-Risk"."Net Income" END
Conditions	< None >
Compound Layout	Title Graph