Calculate percentage in Text object

[qlikvw2019]

Need Help.

I have below expression in the text object , the final output needs to be a % rounded up. Below one is actually giving me with the decimals. Is there a better way to do it?

Output=41.43989 

Expected= 41%  (also how do i add a percentage sign at the end)

=(count({<[Status]={"COMPLETED"}>}[Status])
/count({<[DB Tech]={"SQL","ORACLE","DB2-LUW"}>}[DB Tech])*100)

[sunny_talwar · Accepted solution]

Try this instead

Num(
Count({<[Status] = {"COMPLETED"}>}[Status])
/
Count({<[DB Tech] = {"SQL","ORACLE","DB2-LUW"}>}[DB Tech])
, '#%')

or

Num(
Count({<[Status] = {"COMPLETED"}>}[Status])
/
Count({<[DB Tech] = {"SQL","ORACLE","DB2-LUW"}>}[DB Tech])
, '#.%')