Count If

[#1]

Hi Experts,

I am trying to do a count where the values must be in a specific range.

My first count to check whether my load is less than a Ton works perfectly:

Num(Count ({< CYEAR = {'2012'}, Load = {"<1000"} >} DISTINCT LineNumber),'# ##0')

I now need to count where my load is between 1001 and 3000 and then another that is 3001 to 5000.

Can you please assist in telling me how to add some kind of an If statement into it.?

Thanks in Advance!

Wynand.

[vincent_ardiet · Accepted solution]

Hi,

Try with :

Num(Count ({< CYEAR = {'2012'}, Load = {">1000<=3000"} >} DISTINCT LineNumber),'# ##0')

Regards,

Vincent

[jagan]

Hi,

Try like this

=Num(Count ({< CYEAR = {'2012'}, Load = {">=1000<=3000"} + {">=3001<=5000"} >} DISTINCT LineNumber),'# ##0')

Hope this helps you.

Regards,

Jagan.