Excluding 0 time format from an average

[HereWeGoAgain]

Good Day

Please assist.

I'm trying to exclude zero value from arrival times. the format is the following 1900-01-00 00:00:00.

the formula that I used, but isn't working is the following: time(AVG(if(LoadingArrivalTime<>'0',LoadingArrivalTime)))

[MayilVahanan · Accepted solution]

Hi @HereWeGoAgain 

Are you looking to remove zero hour info? If so,

try like below

AVG(if(Hour(LoadingArrivalTime)<>0,LoadingArrivalTime))

[HereWeGoAgain · Accepted solution]

@MayilVahanan Thank you so much!

[HereWeGoAgain]

Hi @MayilVahanan  How will i also exclude negative numbers/time

[MayilVahanan]

HI @HereWeGoAgain 

Is time in negative? am not sure, for negative numbers, you can try like below

If(YourNumberfield > 0,YourNumberfield )

or

If(Sum(YourNumberfield) > 0, sum(YourNumberfield ))