on 2009 May 05 12:35 AM
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!
>
> 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
>
> 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 #.
>
> 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
>
> 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
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.