Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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] ) )
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] ) )