8.7.26 EaR Frequency Distribution

Table 8-15 EaR Frequency Distribution

Report Name(s)	EaR Frequency Distribution
Description	The report displays the frequency distribution of EaR earnings results.
Dashboards Prompts	Prompt Earning at Risk Prompt EAR_002 As of Date Prompt EAR Process Process Prompt EAR Bucket End Date Bucket End Date Prompt Earning at Risk Set # of Bins Prompt EAR Leg Type Product Type
Report Criteria	"Earnings-at-Risk".Earnings BIN: floor(@{EAR_001}{20}*(Case when "Earnings-at-Risk".Earnings = min("Earnings-at-Risk".Earnings) then 0.01 when "Earnings-at-Risk".Earnings = max("Earnings-at-Risk".Earnings) then 0.99 else ("Earnings-at-Risk".Earningsmin(" Earnings-at-Risk".Earnings)) / (max("Earnings-at-Risk".Earnings) -MIN("Earnings-at-Risk".Earnings)) end))+1 ntile("Earnings-at-Risk".Earnings,10) COUNT(DISTINCT "Earnings-at-Risk"."Rate Path Num") "Earnings-at-Risk"."Rate Path Num"
Conditions	< None >
Compound Layout	Title Pivot Table Graph Pivot Table 2