2 Replies Latest reply: Aug 15, 2016 12:41 PM by Sunny Talwar RSS

    Remove row from average in expression

    Jennie Elliott

      The following is an expression for calculating average food cost. This data is entered once a week.


      avg({$<KEY_FormID={'DRPOS'}, KEY_Report={122}, KEY_Store-={325,210}>}Amount)/100


      For one store, they had to back out the data and re-enter it which results in an extra line (noted as Wrong) which is then throwing off my average for not only this store but other stores using that same formula as it is one large chart with 20 + stores in it. All other stores show two dates, while this one has three.




      How can I factor out the line with the 0.00 amount?