0 Replies Latest reply: Jun 28, 2012 10:34 AM by lratz1234 RSS

    Input Field

      I am trying to find parts that have no sales for the last 12 months. I have all of the columns working correctly except for the input field that is in the table. The issue with the input field is that it's going to try to average the inputted value across all invoice line items and there aren't any. This in turns returns all rows and not just the ones with no sales. Is there a way to just have the input field show up for the parts with no sales?

       

      =InputAvg(INPUT_SALE_PRICE, '/')