Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(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 %
(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 %
THANK YOU SOOOOOOO MUCH!
You save my life! May God bless you alwaysssss 🙂