Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys I have the below formula which is working but Im trying to get the perntage of it any ideas
Correct formula without percentage
count(if(Interventions_ID='4', NEWKEYID))-Count(if( Interventions_ID= '4', PatientsNotAssessed_ID))-(count(if(Interventions_ID='5',NEWKEYID))-Count(if( Interventions_ID= '5', PatientsNotAssessed_ID))),
Here is how Im try to get a percentage by diving it in to ((Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%'))
=NUM((count(if(Interventions_ID='4', NEWKEYID))-Count(if( Interventions_ID= '4', PatientsNotAssessed_ID))-(count(if(Interventions_ID='5',NEWKEYID))-Count(if( Interventions_ID= '5', PatientsNotAssessed_ID))) / ((Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%'))
after num you see a red bracket, so one bracket is missing
the main Problem is that you Need to use brackets around the subtraction
you use Count x - Count y / Count z (by rules it calculates Count y / Count z and subtracts the result from Count x
you Need (Count x - Count y) / Count z
after num you see a red bracket, so one bracket is missing
the main Problem is that you Need to use brackets around the subtraction
you use Count x - Count y / Count z (by rules it calculates Count y / Count z and subtracts the result from Count x
you Need (Count x - Count y) / Count z
Fantastic thanks Mate that worked