Finding the avg of numbers above 0

[joshrussin]

Hey guys,

Im sure there is a simple solution for this, but I guess im just overthinking it.

I'm looking to find the average lead time of the products from yesterday.

The formula is:

Putaway Date (Act:) - Actual Goods Receipt Date

In the attached file, it is shown as that.

But when it averages, it counts in the 0's as well, which give around a 2 average.

I need to average everything above 0 to give me a 9.29 average.

Thanks!

[sunny_talwar]

Which field are you averaging? Quantity?

[sunny_talwar · Accepted solution]

This works

Avg({$<[Lead Time eWM] = {'>0'}>}[Lead Time eWM])

[joshrussin]

Trying to average the "lead time"

[joshrussin]

Well darn, I was close,

this is what I had...

avg({$<[Lead Time eWM] = {$(='>' & '0')}>}[Lead Time eWM])

Thanks so much