Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
I dont know how to check the vActual in condition.
if i select 04 and 05, i need to sum of the actual value of 201104 and budget of 201105 month.
but the expression which i used to sum of the actual value upto 201105 and budget of 201105.