error on percentage expression

[sweens78]

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

[jyothish8807]

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

Just removed your last bracket.

[Frank_Hartmann]

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

[sweens78 · Accepted solution]

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