Using count function

[jyothish8807]

Hi,

I want to count the no of times , two condition are fulfilling for a particular person.

for eg. there are two coloums named " Status" and "Approved " corresponding to different persons.

I want the count coresponding to different persons when status="Done" and Approved="Yes"

iam using the following syntex:

count(if(status='Done' and Approved='Yes',,))

but its not working.....

Regards

Jyothish

[kaushiknsolanki]

Hi,

     Try this.

     Count({<Status = {"DONE"}, Approved= {"YES"}>} PERSON_ID)

Regards,

Kaushik Solanki

[#3]

hi kaushik

can u plz explain me the syntax you wrote

i have similar problem

thanks in advance

[#4]

hi kaushik

can u plz explain me the syntax you wrote

i have similar problem

thanks in advance

[#5]

could u explain me the syntax.

i have similar problem

thanks in advance

[deepakqlikview_123]

Hi,

Count({<Status = {"DONE"}, Approved= {"YES"}>} PERSON_ID)

in a a above expression  Kaushik used set analysis.

This expression is counting PERSON_ID only where status is done and approved is YES that u r trying for.

Thanks

[jyothish8807]

Over here Kaushik is using set analysis.

Count function counts the no of possible outcomes.

Set analysis always start with "{" and finish with "}".In "<" you have to write the condition you want.

In the above syntex he is chacking for the entries whose status="Done" and Approved="Yes". He has grouped these condition to Person ID. So now count function will count all the Person_ID which fullfill both status and Approved condition.

Hope this helps you.

Reards

Jyothish KC