topic Re: Convert count into percentage in Alteryx Designer Desktop Discussions

Convert count into percentage

shahnawaz_khan — Mon, 11 Nov 2024 07:59:33 GMT

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%

Re: Convert count into percentage

OTrieger — Mon, 11 Nov 2024 09:16:19 GMT

@shahnawaz_khan

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

Change the output to String

Re: Convert count into percentage

niklas_greilinger — Mon, 11 Nov 2024 09:22:03 GMT

Hi @shahnawaz_khan,

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

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

Re: Convert count into percentage

Kaustubh17 — Mon, 11 Nov 2024 10:02:10 GMT

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

Re: Convert count into percentage

shahnawaz_khan — Mon, 11 Nov 2024 10:16:13 GMT

Thank you, its resolved now.