Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
share sample qvf