Month To Date

[Lionel_Maximus]

Hello,

I have 2 months of sales(Oct,Nov).

Now i want to compare First 15 Day Sales of Oct to First 15 Day Sales of  Nov.

How can i do that.

Thanks

[anushree1]

You must pass the date range in set analysis 

[Lionel_Maximus]

Hello,

I am Doing This

SFromDate = 10/1/2018    SToDate = 10/15/2018

and in the KPI i am using this expression

Sum({$<SaleDate={$(#SFromDate)>=$(#SToDate)}>}Sales)

but it's not doing anything??? and i want to define the range dynamically as well(How to do that??)

Regards,

[anushree1]

Try this expression:

Sum({$<SaleDate={'<=$(=SFromDate)>=$(=SToDate)}>}Sales)

To make it dynamic please create the dates using mydate.

If you need anything in specific please share the Sample data and desired output

[Lionel_Maximus]

Tried but didn't work

Here's the sample.

and i am using Master Calendar  too.

[anushree1]

I believe the problem is with the quotes,

Please try as below:

=sum({<Date={">=$(#vmindate)<$(vmaxdate)"}>}Sales)

Also it could date format issue , check both the items

Attached is a sample wherein I have used min date and added 15 to it to get the dynamic logic flowing , you may tweak it as per your need

[Lionel_Maximus]

It works. Thank You Soooooo Much. 🙂