2 Replies Latest reply on Jan 25, 2012 6:12 AM by Christopher Henderson

    Lookups and Variances

    Christopher Henderson



      I have been provided with daily sales data by account and by product. What I need to do is to see week by week whether or not there have been changes in the average selling price of our products.


      My data contains a list of around 250 accounts and 500 products and has the fields:





      Average Selling Price


      I need to see whether any individual accounts indidual products have changed in price from the previous week. I would then only like to display products from accounts where the variance is say greater than 5%. This will help me in determining which products from which accounts need to be looked at. Do I need to use the lookup function for this type of work? So that I dont end up displaying every product from every account.