Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you explain your 'selected different year' a bit more? Is it coming from another selection (may be using alternate state)?
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.
Explanation with a sample data set and expected output would be helpful.
Hi,
Try like this
Sum({$<Year={$(=Max(Year))},FiscalYear={*}>} Sales /Only({<Year={$(=Max(Year+1))},FiscalYear={*}>} Currency)
Hope this helps you.
Regards,
Jagan.