Suppressing two sets of data

[Former Member]

I am trying to suppress two different things. I use the section expert and originally used

if {@90th Percentile returned time} = "0" then True

It worked perfectly, but now I want to add

if next({incident.incidentnumber}) = {incident.incidentnumber} then true

What I put was

if {@90th Percentile returned time} = "0" then True

and

if next({incident.incidentnumber}) = {incident.incidentnumber} then true

What I am trying to do is hide or remove some of my erroneous duplicates and I need to suppress anything with a 0.

I appreciate any help!

[Former Member · Accepted solution]

>

> if {@90th Percentile returned time} = "0" then True
> and 
> if next({incident.incidentnumber}) = {incident.incidentnumber} then true
> 
> What I am trying to do is hide or remove some of my erroneous duplicates and I need to suppress anything with a 0.
>

Tim, from your description I'm not quite sure if you are trying to hide records if both are true or to hide them if either is true.

If you want to hide records where both are true (90th=0 AND incident # = incident # for each record) try:

if {@90th Percentile returned time} = "0" AND next({incident.incidentnumber}) = {incident.incidentnumber} then true

If you want to hide records where either is true (90th=0 OR incident # = incident #) try:

if {@90th Percentile returned time} = "0" OR next({incident.incidentnumber}) = {incident.incidentnumber} then true

[Former Member · Accepted solution]

I am trying to do both. I need to hide the erroneous (duplicate) records, then I need to only show the reports that don't have a "0) in the {@90th Percentile returned time} field.

What is happening is we get duplicate incident numbers even though there is only one record in the database. So, I want to hide the extra incident numbers.

[Former Member · Accepted solution]

>

 > What is happening is we get duplicate incident numbers even though there is only one record in the database.  So, I want to hide the extra incident numbers.

Why are you getting more than one record if there is only one in the database?

Try the 'AND' version.... only I'm not sure how CR is going to handle using the next() function and suppressing. You may need filter on the 0 and then group on your incident #.

[Former Member · Accepted solution]

I tried the "and" and it suppressed the duplicates, but did not suppress the "0". If I run them individually, they both work perfect. They just don't work at the same time.

Not sure about the duplicates. We are at a loss on that one.

Edited by: Tim Knudsen on May 5, 2009 1:58 AM

[Former Member · Accepted solution]

>

> I tried the "and" and it suppressed the duplicates, but did not suppress the "0".  If I run them individually, they both work perfect.  They just don't work at the same time.

OK, sounds like you really do want to use the 'OR' statement. If what you are you looking for is:

for each record.... if....

0 and duplicate -> suppress

0 and not duplicate -> suppress

not 0 and duplicate -> suppress

not 0 and not duplicate -> show

.... use the OR

[Former Member · Accepted solution]

I am not sure how to write that for different fields. One field is {@90th Percentile returned time} which has the "0" in it and the other one is {incident.incidentnumber} which gets the duplicates.

I have to thank you for helping me with this. I greatly appreciate it!

[Former Member · Accepted solution]

>

> I am not sure how to write that for different fields.  One field is {@90th Percentile returned time} which has the "0" in it and the other one is {incident.incidentnumber} which gets the duplicates.

Use the same formulas you have now that work separately and just "combine" them into one statement separated by the 'OR' operator...

if {@90th Percentile returned time} = "0" OR next({incident.incidentnumber}) = {incident.incidentnumber} then true

[Former Member · Accepted solution]

That seemed to do the trick! Thank you!