Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I want to add up percentages as seen below but when I go to add I'm getting the decimal point rather than percentage if that makes sense.
So for example instead of returning 9.18% (total of both) it is returning 0.918.
I know it probably the code I need to change?
Any Ideas
Thanks Martin
=Num((count(if (SelfHarmAct_ID= '1' and SubstanceMisuseAlsoAFactor = '1', NEWKEYID))-Count(if (SelfHarmAct_ID = '1' and SubstanceMisuseAlsoAFactor= '1', PatientsNotAssessed_ID)))/(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%') +Num((count(if (SelfHarmAct_ID= '2' and SubstanceMisuseAlsoAFactor = '1', NEWKEYID))-Count(if (SelfHarmAct_ID = '2' and SubstanceMisuseAlsoAFactor= '1', PatientsNotAssessed_ID)))/(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.##%')
Look here
Adding percentges together but getting a decimal