Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You can try using Set Analysis something like
=Count({$<Diagnosis={Cellulitis}, [Patient Admitted]={1}>}Your_field)
Thanks
Manisha
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