Range Expression 2

[MalcolmCICWF]

I want to do a range expression where any of my codes that are 2000's are counted and if they are 2000's-3000's they are counted.The codes range from 1000-5000, but what I am using seems to be counting all the codes no matter what I change the range to. Can anyone help me figure out how to count just specific codes for these in report expressions?

Here is what I have that isnt working.

COUNT(IF(DISPO>=2000,1

and DISPO<=3801,1))

[#2]

I can't see the image you posted, but have you tried using a mapping load in the script? That should do the trick.

[MalcolmCICWF]

Sorry, I have updated the picture in my original post.

[#4]

Hmm. I still can't see it. 😕

[MalcolmCICWF]

I just pasted the damn code this time lol. I also changed up the wording a bit to explain where I am using it. This is on the front end of my report where I am trying to create expressions for a char tin my report.

[#6 · Accepted solution]

To count only the codes in the 2000's:

=Count({<DISPO={">=$(=2000) <=$(=3000)"}>} DISPO)

To count only the codes in the 2000's and 3000's:

=Count({<DISPO={">=$(=2000) <=$(=4000)"}>} DISPO)