Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
if the user selects the Apr month, then i need to show the cumulative value from jan to Apr., then that value is multiplied by the Apr month Exchange amt.
i done that one by using set analysis.
but my problem is , if the user selects mar and Apr, then i need to show two column one is for Mar and another one is for Apr.
in Mar, cumulative value from Jan-Mar then multiplied by the mar month Exchange rate,
in Apr, cumulative value from Jan-Apr then multiplied by the Apr month Exchange rate,
could anyone help me to solve this issue...
thanks in advance....
Hi,
i m using the following expression
Sum({<Num_Select_YearMonth={'<=$(=max(Num_Select_YearMonth))'},
Select_Year={$(=MaxString(Select_Year))},
Ex_MonthYear={'$(=max(Select_YearMonth))'}
>}Amt* Exchange_Amt_Avg)
Its working fine to see only one month...
but i dont know how to do for multiple months, based on the month selection...
Could anyone help me to solve this issue...
thanks in advance...