Normal Formula instead of set analysis

[sweens78]

Hi Guys,

In the formula below , I just want to use a normal formula instead of Set analysis any ideas?

NUM((count({<MentalHealthHistory_ID={'2','3'}>} NEWKEYID))/(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%')

Martin

[trdandamudi]

May be as below:

Num(If(MentalHealthHistory_ID='2' OR MentalHealthHistory_ID='3',Count(NEWKEYID)/Count(NEWKEYID) - Count(PatientsNotAssessed_ID),'##.##%')

[sweens78]

thank you trdandamudi

Should there be a 'count' before the' if 'some where seem to be getting an error with a bracket?