4 Replies Latest reply: Feb 19, 2016 12:32 AM by jagan mohan rao appala RSS

    2 control points in a formula

      Sum({$<Year={$(=Max(Year-1))},FiscalYear={*}>}  Sales / $(vCurrency))

       

      here is the formula for last year sales.

       

      how would you change the formula where you would have sepereta control points for volume sales and currencies?

       

      current situation:     sum( 'selected year' sales / currency )

       

      I am looking for :  sum ('selected year' sales / 'selected different year' currency ) solution on above formula.