Hi Guys I've two formulas below I want to subtract 1 from the other but I think I'm getting the brackets wrong hence wrong answer?
Any ideas of what I might be doing wrong?
Formula 1
count({<NOK_Carer_ID={2}>} NEWKEYID)-count({<NOK_Carer_ID={2}>} PatientsNotAssessed_ID)+count({<NOK_Carer_ID={1}>} NEWKEYID)-count({<NOK_Carer_ID={1}>} PatientsNotAssessed_ID)
Formula 2
count({<NOK_Carer_ID={3}>} NEWKEYID)-count({<NOK_Carer_ID={3}>} PatientsNotAssessed_ID)+count({<NOK_Carer_ID={4}>} NEWKEYID)-count({<NOK_Carer_ID={4}>} PatientsNotAssessed_ID)
Trying to Subtract?
count({<NOK_Carer_ID={2}>} NEWKEYID)-count({<NOK_Carer_ID={2}>} PatientsNotAssessed_ID)+count({<NOK_Carer_ID={1}>} NEWKEYID)-count({<NOK_Carer_ID={1}>} PatientsNotAssessed_ID) -count({<NOK_Carer_ID={3}>} NEWKEYID)-count({<NOK_Carer_ID={3}>} PatientsNotAssessed_ID)+count({<NOK_Carer_ID={4}>} NEWKEYID)-count({<NOK_Carer_ID={4}>} PatientsNotAssessed_ID)
