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.

[sasikanth]

hi,

try some thing like below

use if condition inside Count function

COUNT( IF ( BranchID='A' and ([has initial examination] = '1', PaientID) )

[Anonymous]

may be this:

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

[#4]

Hi Mohammed, you can try this four options:

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

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

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

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

It depends if [has initial examination] is a string or number.

I hope that it help you!

Regards, Agustin

[#5]

hi Mohmd,

i think below expression should work

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

if not please share sample data to understnd the same properly