Wrong average between dates

[#1]

Hello!

I'm desperated and very thankful for everybody who could take a look at my attachment (can find problem and explanation in here).

In one case it is working, but the second one does not although I'm using the same method.

I mean the sum is right, the count is right, but the average isn't...

So many thanks!

[Clever_Anjos · Accepted solution]

Just formatting issue...

or apply

=interval(Sum({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDir_TimeToOwn)/

Count({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDirect_ID))

OR

=(Sum({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDir_TimeToOwn)/

Count({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDirect_ID) * 24

[#3]

Awesome!

Made my day - so many thanks!