Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks for your response Kaushik, Can you please provide me with an example
Something like this
=num(Count({<Rental_Date = {">=$(=(MonthStart(Max(Rental_Date))))<=$(=Today())"}>}Rental_Store),'##,##0')
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.
I tried everything I could. I still find the solution to my problem. Please advice anyone
Hi Provide some sample data and QVF which shows your issue.
@avinashelite wrote: DGCustomerFirstSomething like this
=num(Count({<Rental_Date = {">=$(=(MonthStart(Max(Rental_Date))))<=$(=Today())"}>}Rental_Store),'##,##0')
Hi, i tried those method but didnt work for me…
Please provide the sample data to work on that will help us to provide the 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.