Issue with set analysis

[nareshthavidishetty]

Hi,

I have used the below set analysis.

=Sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={">$(=Date(monthend(max([Calendar Date]),-6)) ,'DD-MMM-YYYY') <=$(=Date(monthend(max([Calendar Date]),-5)) ,'DD-MMM-YYYY'))"}>}[# Open])

Is there anything wrong with the above logic.

Because when i tested in text box I'm getting both the results means with and without set analysis were same.

Thanks..

[olivierrobin]

hello

if you have the same result with and without set analysis, it means you set analysis filters nothing

Just a question : isn't you formula equals to Calendar date=max(date)-5 ?

[nareshthavidishetty]

Yes

[olivierrobin]

so you can simplify you formula

did you verify that :

you have data corresponding to the selection

the format of the date field is correct

?