Avg function not giving any value in graph.

[#1]

Hi,

I have below kind of data available for my enquiries, and I am trying to calculate Avg Rate. while computing avg rate, I have to ignore null rate and negative rate from table. Can somebody help me to put correct formulate to compute this.(values are smudged for privacy reason)

currently I have put below as formula

Avg(Aggr(Only({<Status = {'*Order*'},UNITRATE>= {0} >} UNITRATE), ENQNO)) AND MY GRAPH SHOWS AS BELOW.

[sunny_talwar · Accepted solution]

May be like this

Avg(Aggr(Only({<Status = {'*Order*'}, UNITRATE = {'>0'}>} UNITRATE), ENQNO))