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.