1 Reply Latest reply: Jul 4, 2011 5:49 AM by Gopinathan L RSS

    Cumulative and Exchange rate

    Gopinathan L

      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....

        • Re: Cumulative and Exchange rate
          Gopinathan L

          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...