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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filters

Status
Not open for further replies.

SorryDog777

Programmer
Jun 26, 2003
15
US
I'm very new to Impromptu 7 and need to write a simple (should be to me) report showing total off quality totals and then underneath the off quality show total first quality.

I have a list report working fine for off quality with a filter that excludes the first quality.

Off Quality Example: Date >= ?StartDate? and Date <= ?EndDate? and Code <> 'A' or Code <> 'P'
Note: Other codes signify off quality.
This works fine.



When I create a calculation filter for first quality which looks something like:

If (Code = 'A' or Code = 'P') then (Qty) else (0)
When I total the above I all zeros.

I just haven't learned enough about the report writer yet to locate the problem.

Any ideas to get a total first quality?

A step by step would be appreciated.

Thanks



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top