How to show prior year with missing future dates ?

[Anonymous]

Hi everyone !

I need a set analysis expression that shows values from last year at current year selection

Select 2017 :  Show 2016

All of 2016 Q1, Q2, Q3, Q4  values are available

But values for 2017 are partially missing :  Q3, and Q4  ( Apr - Sept) are not available.

Do you have to have complete values for both 2017 and 2016  for set analysis to work ?

[FISCAL YEAR] ,[FISCAL QUARTER]  Month

Expression : num( ($(vFXImpactvsPY)) *(vDivider),MoneyFormat)

Unable to share sample app - too big

[vishsaggi]

May be like:

= num( Sum({< [FISCAL YEAR] = {$(Max([FISCAL YEAR])-1) } >}(($(vFXImpactvsPY)) *(vDivider))),MoneyFormat)