Change value to percentage

[nurulizzaty]

Hello experts,

I have this expression to detect either the case is accident or not, then i will display the factor of the case. BUT, how do i display the value as in percentage? 

Count({$<[INCIDENT_TYPE]={'Accident'}>}FACTOR_1)

The percentage should calculate by num of factor/total factor * 100 right? But how do i write it with the expression above?

Need your help asap. Thank you so much.

Regards,

Zety

[UserID2626 · Accepted solution]

(Count({$<[INCIDENT_TYPE]={'Accident'}>}FACTOR_1) / Count( Total {$<[INCIDENT_TYPE]=>}FACTOR_1))*100

or

(Count({$<[INCIDENT_TYPE]={'Accident'}>}FACTOR_1) / Count( Total {$<[INCIDENT_TYPE]=>}FACTOR_1))

and change number format to %

[nurulizzaty]

THANK YOU SOOOOOOO MUCH! 

You save my life! May God bless you alwaysssss 🙂