topic Re: error on percentage expression in Water Cooler

error on percentage expression

sweens78 — Wed, 14 Nov 2018 10:21:23 GMT

Hi Folks,

I have the below expression that I am trying to get a pertage for and it keeps coming back with an error, is it a bracket?

num((Count({<SubstanceMisuseAlsoAFactor={'1'}>} NEWKEYID)-Count({<SubstanceMisuseAlsoAFactor={'1'}>} PatientsNotAssessed_ID))
+
(Count({<SubstanceMisuseAlsoAFactor={'2'}>} NEWKEYID)-Count({<SubstanceMisuseAlsoAFactor={'2'}>} PatientsNotAssessed_ID))
+
(Count({<SubstanceMisuseAlsoAFactor={'3'}>} NEWKEYID)-Count({<SubstanceMisuseAlsoAFactor={'3'}>} PatientsNotAssessed_ID)))

/

((Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.#'))

Re: error on percentage expression

jyothish8807 — Wed, 14 Nov 2018 10:28:35 GMT

Try this:

Just removed your last bracket.

Re: error on percentage expression

Frank_Hartmann — Wed, 14 Nov 2018 10:37:24 GMT

Maybe this:

=num(Count({<SubstanceMisuseAlsoAFactor={'1'}>} NEWKEYID)-Count({<SubstanceMisuseAlsoAFactor={'1'}>} PatientsNotAssessed_ID)
+
Count({<SubstanceMisuseAlsoAFactor={'2'}>} NEWKEYID)-Count({<SubstanceMisuseAlsoAFactor={'2'}>} PatientsNotAssessed_ID)
+
Count({<SubstanceMisuseAlsoAFactor={'3'}>} NEWKEYID)-Count({<SubstanceMisuseAlsoAFactor={'3'}>} PatientsNotAssessed_ID)
 
/

(Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.#')

hope this helps

Re: error on percentage expression

sweens78 — Wed, 14 Nov 2018 11:24:12 GMT

Great stuff, just had to put an extra bracket around the divisional part and it worked see below

=num(Count({<SubstanceMisuseAlsoAFactor={'1'}>} NEWKEYID)-Count({<SubstanceMisuseAlsoAFactor={'1'}>} PatientsNotAssessed_ID)
+
Count({<SubstanceMisuseAlsoAFactor={'2'}>} NEWKEYID)-Count({<SubstanceMisuseAlsoAFactor={'2'}>} PatientsNotAssessed_ID)
+
Count({<SubstanceMisuseAlsoAFactor={'3'}>} NEWKEYID)-Count({<SubstanceMisuseAlsoAFactor={'3'}>} PatientsNotAssessed_ID)

/

((Count(NEWKEYID)-Count(PatientsNotAssessed_ID)),'##.#%'))