How to show prior year with missing future dates ?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to show prior year with missing future dates ?

vishsaggi — Fri, 28 Apr 2017 17:06:38 GMT

May be like:

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