number of days in a month

Reply
White Belt

number of days in a month

 

I have a monthly amount that I need to spread equally over the number of days in the month. The data looks like this:

Month       Value
01-Jan-2012 100000
01-Feb-2012 121002
01-Mar-2012 123123
01-Apr-2012 118239

I have to spread the Jan amount over 31 days, the Feb amount over 29 days and the March amount over 31 days. So I can graph it by Day and by an average. Help.

Major Red Belt

Re: number of days in a month

 

So you can calculate the average daily amount by doing something like this:

 

`Value` / DAY(LAST_DAY(`Month`))

That will convert each month value to the last day of said month and then strip the day value from it. 

 

So it would be 100000/31 for January and 121002/28 for February etc..

 

Hope this helps, let me know if you have any other questions.

Valiant

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

Announcements
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!