3 Replies Latest reply: Feb 5, 2018 7:13 AM by omar bensalem

Last 12 months restriction

bhavani b Feb 5, 2018 6:48 AM

Hi Experts,

Can any one please help me on below requirement.

In the YearMonth Field I have records from 2017/01 to 2018/02.

Here I have to restrict last 12 months

Sum({<YearMonth={">=$(=Max(YearMonth)-12) <$(=Max(YearMonth))"}>}Sales)

with the above expression when I have selected 2018/01 then getting last 12 months from 2017/01 to 2017/12

but when i have selected 2018/02 then getting last 13 months from 2018/01 to 2017/01 but need to get 2018/01 to 2017/02.

How to get this. Please help me on it. Please find the attached Document.

Thanks in advance

Re: Last 12 months restriction

omar bensalem Feb 5, 2018 7:08 AM (in response to bhavani b)
It's not taking into consideration the >=$(=Max(YearMonth)-12) part

change ur expression as follow:
=Sum({<YearMonth={">=$(=date(addMonths(Max(YearMonth),-12),'YYYY/MM')) <$(=Max(YearMonth))"}>}Sales)

result:

see the attached app:

Month-Sort App.qvf 208.0 K
Like Show 0 Likes (0)

Actions
Re: Last 12 months restriction

Jonathan Dienst Feb 5, 2018 7:10 AM (in response to bhavani b)

Sum({<YearMonth={">$(=Max(YearMonth)-12) <$(=Max(YearMonth))"}>}Sales)
Like Show 0 Likes (0)

Actions
- Re: Last 12 months restriction
  
  omar bensalem Feb 5, 2018 7:13 AM (in response to Jonathan Dienst )
  
  No, that won't do it Jonathan;
  in fact, in this case:
  =date(Max(YearMonth)-12,'YYYY/MM') would go back by 12 days:
  
  Like Show 0 Likes (0)
  
  Actions