Hi all,
I am creating a BEx report where I have two variables, the first variable (VarA) is populated through a dop-down list on which the user selects upon the report loading, the second variable (Var2) is required to get it's value from a calcuation based on Var1.
------------------------------------------------------------------------------------------------------
For example:
Var1 has the selected the value 'March 2012'
Var2 is then to have the value of 'August 2012'
or
Var1 has the selected value of 'August 2012'
Var2 is then to have the value of 'August 2012'
------------------------------------------------------------------------------------------------------
The condition is simple, if the Var1 is August YearX then Var2 has the same value. If Var1 is not August YearX then Var2 is to have a previous August YearX.
How is this done? Thanks.