Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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])
, '#.%')
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])
, '#.%')