Convert count into percentage

[shahnawaz_khan]

Hi All

I am trying to convert below report count into percentage eg:

Input data

Status	0 - Day	1 - Day	2 - 5 Days	6 - 10 Days	11 - 14 Days	> 14 Days	Total
Closed	23244	34324	23423	39898	32334	8878	162101

Output data

Status	0 - Day	1 - Day	2 - 5 Days	6 - 10 Days	11 - 14 Days	> 14 Days	Total
Closed %	14%	21%	14%	25%	20%	5%	100%

[OTrieger]

@shahnawaz_khan 

You can do it with Multi field formula. Just write the following formula ([_Current Field_]/[Total])*100+"%"

Change the output to String

[niklas_greilinger · Accepted solution]

Hi @shahnawaz_khan,

you could use a multi field formula.
I included a configured tool.

Formula:
tostring(Round([_CurrentField_]/[Total]*100, 1))+"%"

[Kaustubh17 · Accepted solution]

Hi @shahnawaz_khan 

PF below solution for your issue. You can accomplish using multi field formula tool.

if above solution resolve the issue please select as solved to help community member with the same query.

Best Regards,

Kaustubh

[shahnawaz_khan · Accepted solution]

Thank you, its resolved now.