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

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

• ###### Re: 2 control points in a formula

Can you explain your 'selected different year' a bit more? Is it coming from another selection (may be using alternate state)?

• ###### Re: 2 control points in a formula

so on top I created options to select Fiscal Year drop down where you can select from 2012 to 2015.  I would like to be able to manipulate the expression where I can select 2015 which would give me 2015 sales but also be able to (hard code option is OK too) to select 2016 for currency data.  in other words - take last year sales with this year currency values.

• ###### Re: 2 control points in a formula

Explanation with a sample data set and expected output would be helpful.

• ###### Re: 2 control points in a formula

Hi,

Try like this

Sum({\$<Year={\$(=Max(Year))},FiscalYear={*}>}  Sales /Only({<Year={\$(=Max(Year+1))},FiscalYear={*}>} Currency)

Hope this helps you.

Regards,

Jagan.