Problem with SUM

[ddrafts]

I’m really new at this. I’m using cr10. I’m trying to sum a field but it is not returning the correct amount. Here is what I’m using.

//@EscN
If {Incident.Escalation} = "No" then 1

//@EscNsum
Sum ({@EscN})

//@EscY
If {Incident.Escalation} = "Yes" then 1

//@EscNsum
Sum ({@EscY})

They should show EscN = 228 but comes up as 222 and EscY = 51 but should be 50. I’m really not sure what is wrong. Any help would be great.

Thanks
Doug

 

[synapsevampire]

You might try:

If trim({Incident.Escalation}) = "Yes" then
1
else
0

If that fails, are you certain that some aren't mispelled or there's a case sensitivity?

Check it by grouping on the Escalation field and suppressing the details, you should see allof the possibilities in the field, which may be numerous, somewith spaces and a word, just spaces, nulls...

-k