AnsweredAssumed Answered

Help for omitting records with dates that have multiple price points

Question asked by suite48 on Jul 29, 2009
Latest reply on Jul 30, 2009 by 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

Outcomes