Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,m trying to divide one expression into another but Im getting an error Any ideas? Could be bracket
=num((Count({<CNSBridgingFollowup_ID={'1'}>} NEWKEYID)-Count({<CNSBridgingFollowup_ID={'1'}>} PatientsNotAssessed_ID))+Count({<CNSBridgingFollowup_ID={'2'}>} NEWKEYID)-Count({<CNSBridgingFollowup_ID={'2'}>} PatientsNotAssessed_ID))
/
((Count(NEWKEYID)-Count(PatientsNotAssessed_ID)-(Count({<NextReferralCareAppt_ID={'7'}>} NEWKEYID)-Count({<NextReferralCareAppt_ID={'7'}>} PatientsNotAssessed_ID)),'##.#%'))
Try this
=Num( (Count({<CNSBridgingFollowup_ID = {'1'}>} NEWKEYID) -Count({<CNSBridgingFollowup_ID={'1'}>} PatientsNotAssessed_ID) + Count({<CNSBridgingFollowup_ID = {'2'}>} NEWKEYID) - Count({<CNSBridgingFollowup_ID = {'2'}>} PatientsNotAssessed_ID)) / (Count(NEWKEYID) - Count(PatientsNotAssessed_ID) -Count({<NextReferralCareAppt_ID = {'7'}>} NEWKEYID) + Count({<NextReferralCareAppt_ID = {'7'}>} PatientsNotAssessed_ID))
,'##.#%')
=num(
((Count({<CNSBridgingFollowup_ID={'1'}>} NEWKEYID)
-
Count({<CNSBridgingFollowup_ID={'1'}>} PatientsNotAssessed_ID))
+
(Count({<CNSBridgingFollowup_ID={'2'}>} NEWKEYID)
-
Count({<CNSBridgingFollowup_ID={'2'}>} PatientsNotAssessed_ID)))
/
(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)-Count({<NextReferralCareAppt_ID={'7'}>} NEWKEYID) - Count({<NextReferralCareAppt_ID={'7'}>} PatientsNotAssessed_ID))
,'#.##%')
FYI, Brackets are mis-placed