Joined: 10 Jan 2012
Online Status: Offline
Posts: 12
Topic: Date Range Posted: 11 Jan 2012 at 6:15pm
Hello Everyone,
I have monthwise report when m giving date Range from Oct-2011 to current date so it is taking full month for oct, nov, dec & 10 days for jan as today is 10th of jan. So what i want is it should come 1 to 10th of each month not the full month. Means if Current date is 12th so the figure should come for only 12 days for every month.
Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Posted: 12 Jan 2012 at 3:59am
Does the date field within the data have daily dates? Or does it just include the month? If it only includes the month the formula will have to calculate the percentage into the current month we are and then apply that percentage to the other months. If it contains daily information we can create a more precise formula that will work on day of previous months.
Joined: 10 Jan 2012
Online Status: Offline
Posts: 12
Posted: 13 Jan 2012 at 6:28pm
Dar Mr. Ryan,
The data is datewise but i ve createds a crosstab where it is showing monthwise like Jan-11, Feb-11 & Mar-11. Now for eg if todays date is 12 Mar-2011 & i am giving a range from Jan-2011 to till date so the figures are appearing for full month of Jan & Feb & 12 days for the month of mar as the curent date is 12th mar. so for compariosin purpose i want it show figures for 1-12th of every month.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
