Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used the below logic to get the results as rollback months.But I'm getting same results for all as below.
Logic1 :
=num(Sum({$<[Month Abbr]=, Year=, [Quarter Name]=,[Calendar Date]={">$(=Date(AddMonths(max([Calendar Date]),-3)),'DD-MMM-YYYY') <=$(=Date(AddMonths(max([Calendar Date]),-2)),'DD-MMM-YYYY'))"},[Age Days 90 Flag]={'Y'},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# SCAR Open])
/Sum({$<[Month Abbr]=, Year=, [Quarter Name]=,[Calendar Date]={">$(=Date(AddMonths(max([Calendar Date]),-3)),'DD-MMM-YYYY') <=$(=Date(AddMonths(max([Calendar Date]),-2)),'DD-MMM-YYYY'))"},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# SCAR Open]),'#0.0%') = 17.1%
Logic2:
=num(Sum({$<[Month Abbr]=, Year=, [Quarter Name]=,[Calendar Date]={">$(=Date(AddMonths(max([Calendar Date]),-4)),'DD-MMM-YYYY') <=$(=Date(AddMonths(max([Calendar Date]),-3)),'DD-MMM-YYYY'))"},[Age Days 90 Flag]={'Y'},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# SCAR Open])
/Sum({$<[Month Abbr]=, Year=, [Quarter Name]=,[Calendar Date]={">$(=Date(AddMonths(max([Calendar Date]),-4)),'DD-MMM-YYYY') <=$(=Date(AddMonths(max([Calendar Date]),-3)),'DD-MMM-YYYY'))"},[Conformed Status] -= {'Monitoring*', 'Effectiveness Check'}>}[# SCAR Open]),'#0.0%') = 17.1%
even though the logic is restrict to months it is giving same results.
Thanks..
Would do you mean 'same results'? Would you be able to share a sample?
HI,
Kindly find the attached document.
Thanks..
Would you be able to tell us what is not right in the attached sample and what should it be?
I'm getting same results for the months feb to nov.
It should suppose to be different.
The calendar is not picking up right while calculating the logic.
Thanks..
Hi,
Any idea! Let me know why my set analysis is behaving like this.
Thanks..