Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Awesome!
Made my day - so many thanks!