rolling months not working properly

[nareshthavidishetty]

Hi,

I have used the below logic to roll back to 12 months.

example:

But when i select  like Mar2018 it is roll back to 12 months.

But when i select Feb2018 a few months data were missing.

Logic Used:

if(isnull(Sum({$<[Month Abbr]=, Year=, [Month Year]=,[Quarter Name]=, [Calendar Date]={"$(=date(AddMonths(monthend(floor(Max([Calendar Date]))),-5),'DD-MMM-YYYY'))"}>}[# AR Open])),null(),

Sum({$<[Month Abbr]=, Year=,[Month Year]=, [Quarter Name]=, [Calendar Date]={"$(=date(AddMonths(monthend(floor(Max([Calendar Date]))),-5),'DD-MMM-YYYY'))"}, [Age Days 90 Flag] = {'Y'},[Monthly Snapshot Flag]= {1},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# AR Open])/

  Sum({$<[Month Abbr]=, Year=,[Month Year]=, [Quarter Name]=,[Calendar Date]={"$(=date(AddMonths(monthend(floor(Max([Calendar Date]))),-5),'DD-MMM-YYYY'))"},[Monthly Snapshot Flag]= {1},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# AR Open]))*100

Thanks..

[agomes1971]

Hi,

please read this:

Set Analysis for Rolling Periods

HTH

André Gomes

[ChennaiahNallani]

share sample qvf