Counting text objects

[#1]

Hi again,

Another question for you. I want to count a set of post where one of the variables is a text entry. I have a few different statuses; "Draft", "Approved" and "Evaluation" and in an chart expression I am trying to do something like this:

COUNT(DISTINCT IF(status<>"Approved",name))

What this is to result in is a number of the post where the status is "Approved". Seems easy enough, but I cant get it to work. Thoughts?

Cheers,

[Gysbert_Wassenaar]

Try count({<status-={'Approved'}>} distinct name). Make sure to use the exact case-sensitive field names and values. If you need more help, please post a sample document that demonstrates the problem.

[swuehl · Accepted solution]

COUNT(DISTINCT IF(status<>"Approved",name))

What this is to result in is a number of the post where the status is "Approved". Seems easy enough, but I cant get it to work. Thoughts?

Do you want to get the result for status is equal 'Approved' or is not equal 'Approved'? Your expression is calling for is not.

If you want to check for equal, then use either

=COUNT(DISTINCT IF(status = 'Approved',name))

{note also the single quotes}

or

=COUNT({<status = {Approved}>} distinct name)

[#4]

excellent! thank you!

naturally i meant "=" and not "<>", that was just a brain crash on my end, good that you caught that . i think my biggest problem with this was mainly that i was using a " when i should have been using '. you live and learn i guess ...