I have attached my model.
Jul 2013 Aug 2013
Sales Plan (Planner Forecast ) : 430 236
Projected Adjustment : 0 0
RISK : 430 666
and so on....
RISK for jul 2013 ( Sales Plan(Jul 2013) - Projected Adjustment)
RISK for Aug 2013 ( RISK(Jul 2013) + Sales Plan(Aug 2013) - Projected Adjustment) and so on...
My model is working fine when I am selecting only one Fiscal Year but if I select two Fiscal year then RISK is calculating error.
I have calculated the RISK with the help of two variable vUnit and nRisks ... please check the calculation.
