Monthly average from 06:00. Might be simple but I´m getting lost. What to calculate the average from 06:00 the first day of each month to 06:00 the first day of next. Having trouble around midnight and getting strange values. Any smart ideas?

Thanks!

Found out the reason I got strang values is because om leap year. I tried bacfill on the previous month instead and it worked out just fine.

Using the function yearday and it goes wild in February. Any ideas why that is and solutions?

I just tried the Yearday('*') function, and it works fine in my system. Did a recalc daily since 1-Jan, and no unexpected results. Perhaps you can add a screenshot of your calculation, it'll make the issue easier to spot.

The yellow ones are between 00:00-06:00.

The yellow ones are between 00:00-06:00.