Hi All,
We are using HFM 11.1.2.3 classic version. I would like to know in this version wheather 'if' statement works for dynamic rule. If it does not work please suggest how could I acheive the below query. Im not able to test it in Development due to some restrictions.
Existing rule: This is the existing rule which runs for all scenarios i.e Actual, Budget, Flash and Forecast
HS.Dynamic "A#K_EPS.W#QTD = A #S_Net_Earnings_QTD.I#[ICPTop].C3#TopC3/A#S_Shares_QTD.I#[ICP Top].C3#TopC3"
Need rule to be: I would need this rule to be applicable only for Actual and Flash scenario but for Budget and Forecast it should follow the other rule. Can this be acheived like the below?
If pov_scenario= "Actual" or pov_scenario = "Flash" then
HS.Dynamic "A#K_EPS.W#QTD =A #S_Net_Earnings_QTD.I#[ICPTop].C3#TopC3/A#S_Shares_WAVG_Dil_QTD.I#[ICP Top].C3#TopC3"
else
HS.Dynamic “A# K_EPS.W#QTD= A#K_EPS_YTD”
Thanks in advance !
Regards,
Chandu