onth over Month chart - Formula * Days in Month

[mp802377]

I need to create a month over month chart.  I have successfully created a hourly and daily chart.

Formulas used:

Hourly:  ($(varA) * $(varB) * $(varC)) / 3600

Daily:   ($(varA) * $(varB) * $(varC)) / (3600*24)

How would I create the expression for the month over month chart? Is there  something like in Excel EOMONTH where I can create the formula like:

($(varA) * $(varB) * $(varC)) / (3600 * 24 * DaysInMonth)?

Is there an option for Days in Week? I cannot use (3600 * 24 * 7) because current week might only be 1 or even 5 days.

[brunobertels · Accepted solution]

hi 

here a way to count days in month 

E.g : 

day(monthend(today() ) ) 

will give 30 for novembre 

So DaysInMonth could be 

day(monthend([month_field] ) )