Adding Percentages but come up as a decimal

sweens78 — Wed, 25 Nov 2020 16:16:04 GMT

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)),'##.##%')

Re: Adding Percentages but come up as a decimal

sunny_talwar — Fri, 02 Nov 2018 13:02:12 GMT

Look here

Adding percentges together but getting a decimal

topic Adding Percentages but come up as a decimal in QlikView

Adding Percentages but come up as a decimal

Re: Adding Percentages but come up as a decimal