Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Retrieve data outside a range
You are right. SORRY. I goofed on my desired output, it should be: 1997 5p 45000 75.00 1997 5p 44000 120.00 1997 5p 7000 100.00 1997 5p 6000 150.00 Because all four units are more than 20% different. I am...- wyardjeff
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Retrieve data outside a range
Sorry about including my wrong solution. The result I am looking for isn't an average of the whole model line, It is a variance when two of the same year/model have roughly the same usage but widely varying price. I would like exclude models from the report that have been priced close to same...- wyardjeff
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Retrieve data outside a range
Hello, Our sales guys want me to write a report that returns the models that sold for more or less than comparable units. I am using crystal 8.5 quering an access 97 database. The data looks like: Year model # of cycles Sale price 1997 5p 45000 75.00 1998...- wyardjeff
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
