Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sweens78
Creator
Creator

Percentage not showing proper result

Hi Guys Im trying to divide one expression into another but for some reason is giving me a bi percentage Im sure its just the brackets could you have a look? num((Count({} NEWKEYID)-Count({} PatientsNotAssessed_ID))+(Count({} NEWKEYID)-Count({} PatientsNotAssessed_ID)) / ((Count(NEWKEYID)-Count(PatientsNotAssessed_ID))-((Count({} NEWKEYID)-Count({} PatientsNotAssessed_ID)))),'##.#%')

1 Reply
sunny_talwar

Try this

Num((Count({} NEWKEYID) - Count({} PatientsNotAssessed_ID) + Count({} NEWKEYID) - Count({} PatientsNotAssessed_ID))/
(Count(NEWKEYID) - Count(PatientsNotAssessed_ID) - Count({} NEWKEYID) - Count({} PatientsNotAssessed_ID)), '##.#%')