1 Reply Latest reply: Oct 15, 2016 5:49 PM by Sunny Talwar RSS

    Avg function not giving any value in graph.

    Nitin Jadhav

      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.