Set analysis

[nareshthavidishetty]

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..

[sunny_talwar]

Would do you mean 'same results'? Would you be able to share a sample?

[nareshthavidishetty]

HI,

Kindly find the attached document.

Thanks..

[sunny_talwar]

Would you be able to tell us what is not right in the attached sample and what should it be?

[nareshthavidishetty]

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..

[nareshthavidishetty]

Hi,

Any idea! Let me know why my set analysis is behaving like this.

Thanks..