Sum(IF(and function

[helen_pip]

Hello

I am trying to write a Sum(If(And function and am getting a little stuck

My function currently reads as:

))

My error starts at the first comma

Does anyone know how I can achieve this?

Many Thanks

Helen

[manisha_uit]

Hi,

You can try using Set Analysis something like

=Count({$<Diagnosis={Cellulitis}, [Patient Admitted]={1}>}Your_field)

Thanks

Manisha

[MayilVahanan]

Hi

Try like this

Sum(IF(Diagnosis='Cellulitis' and  [Patient Admitted?]=1),1,0))

or

=Count({$<Diagnosis={'Cellulitis'}, [Patient Admitted]={1}>}Your_field)

Hope it helps