Correct Expression

[Anonymous]

I try to calculate the total patient in  branch 'A' where Initial examination = 1

i try:

if(BranchID={'A'}) and ([has initial examination] = {'1'}), count(PaientID))

but it doesn't working.

[roger_stone]

Have you spelt PatientID correctly?

[vikasmahajan]

=Count( {<  BranchID={'A'} ,[has initial examination] = {'1'} >}  PaientID)

[#4]

Maybe you can try this,

if((BranchID='A') and ([has initial examination] = 1), count(PaientID))

[Chanty4u]

u hve one extra brace....")"

please remove dis

[Anonymous]

You can try:

if(BranchID='A', count(Distinct {<[has initial examination] = {'1'}>} PaientID))

Also check the spelling of PaientID, are you sure it is not PatientID?

[#7]

try this with and with out single quoates for 1

count({< BranchID={'A'} ,[has initial examination] = '1'>}PaientID)

[settu_periasamy]

May be like this

     if(BranchID='A' and [has initial examination] = '1', count(PaientID))

[tyagishaila]

I hope, below expression must work.

=Count({< BranchID ={'A'}, [has initial examination] = {1} >} PatientID)

Correct Expression

[Chanty4u]

hi,

=Count({< BranchID ={'A'}, [has initial examination] = {'1'} >} PatientID)