Dear All,
I want to show the Actual and Budget values by companywise
if there is no actual value for that month then i have to show the budget value.
also the actual suppose to be like ytd. i.e, starting period is unknown, ending period is max of month and year of the user selection
i used the the variable vActual which is used to store the actual period. i.e.,I have the actual value upto that period.(user input)
previously i used the expression to calculate the actual like
sum({<Num_Monthyear={'<=$(=max(Num_MonthYear))'}>},Amount)
-
sum(({<Num_Monthyear={'<=$(=max(Num_MonthYear)-1)'}>},Amount)
if my vActual is 201104. if i select 201105 then i need to show the budget value instead of actual by companywise.
the expresion is like sum(Budget)
also if select 04 and 05 then i need to combine the value of actual and budget.
i.e.,
sum({<Num_Monthyear={'<=$(=max(Num_MonthYear))'}>},Amount)
-
sum(({<Num_Monthyear={'<=$(=max(Num_MonthYear)-1)'}>},Amount)
+sum(Budget)
could anyone help me to resolve this issue....
