Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You must pass the date range in set analysis
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,
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
Tried but didn't work
Here's the sample.
and i am using Master Calendar too.
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
It works. Thank You Soooooo Much. 🙂