14 Replies Latest reply on Jul 30, 2009 9:47 AM by suite48

    Help for omitting records with dates that have multiple price points

    suite48

      Title

      Help for omitting records with dates that have multiple price points

      Post

      I'm a beginner, so any help appreciated!  I'm trying to pull data together to calculate price elasticity. 

       

      I have a date field and a price (i.e. number) field.  I want to perform a bunch of searches for distinct price points (say starting with one for $49) and only find records if on that date we sold the product only for that particular price (it is not sold at different prices that date). 

       

      E.g. if on February 2 we sold the same product one time for $49 and one time for $59, I want to omit any records with that date when searching for $49.

       

      Any suggestions?

       

      tx,

       

      hans