Set Anaylsis filter is changing based on Selection

[has3240]

Hi Everyone,

I am running into a strange issue. My MTD set analysis is working fine, but the moment I select a specific store somehow my set analysis is ignoring my MTD To filer. 

=num(Count({<Rental_Date = {">=$(=(MonthStart(Max(Rental_Date))))<=$(=Max(Rental_Date))"}>}Rental_Store),'##,##0')

Without Store Selection Filter

With Store Selection Filter

[kaushiknsolanki]

Hi,

It is because when you don't select store the Max date is something else (Probably the current Month), whereas when you select store the Max Date is changed and you see different results.

Make sure you use Today() function then Max Date.

[has3240]

Thanks for your response Kaushik, Can you please provide me with an example

[avinashelite]

Something like this 

=num(Count({<Rental_Date = {">=$(=(MonthStart(Max(Rental_Date))))<=$(=Today())"}>}Rental_Store),'##,##0')

[has3240]

Hi Avinash,

Thanks for your reply. Still facing the same issue. If I select Store 136 its gives me the correct value, but any store which doesn't have a value store selection is ignoring my date parameters. 

[has3240]

I tried everything I could. I still find the solution to my problem. Please advice anyone

[kaushiknsolanki]

Hi Provide some sample data and QVF which shows your issue.

[Lashaunda79]

---

@avinashelite wrote: DGCustomerFirst

Something like this 

=num(Count({<Rental_Date = {">=$(=(MonthStart(Max(Rental_Date))))<=$(=Today())"}>}Rental_Store),'##,##0')

---

Hi, i tried those method but didnt work for me… 

[avinashelite]

Please provide the sample data to work on that will help us to provide the solution 

[has3240 · Accepted solution]

Hi Kaushik,

You were right that the Max date is changing when I select a store. 

">=$(=(MonthStart(Max(Rental_Date))))<=$(=Max(Rental_Date))"

So far this date filter is working for me ">=$(=MonthStart(AddMonths(Today()-1,0)))<$(=Today())"

I know it's working for now, but I don't know if this is the right formula to be using or not.