Calculating percentage in alteryx

[suds144]

Hello everyone,

I've been trying to calculate the % of attendance to an event by society. Ideally I would like to have a column in alteryx that showcases the % of attendance to an event (taking into account the total number of students in the society and the total number of events attended). 

Ideal output

Thank you

[binuacs]

@suds144 

[atcodedog05 · Accepted solution]

Hi @suds144 

Just adding to @binuacs approach which meets the requirement. Note that when you display with % sign it will turn to string. You show it without percentage so that it is treated as number.

Hope this helps : )

[suds144]

Thank you! I just tried this but got an error "Tried to apply numeric operator to string value". How do I rectify this?

[atcodedog05 · Accepted solution]

Hi @suds144 

Use a select tool and convert datatype to double.

Workflow:

Hope this helps : )

[suds144]

This helps a lot! Thank you!

In certain cases the total number of events attended is higher than the number of students in the society. This is giving a very high %.

For example

There isn't anything I can do about this. It's just skewing the data.

[atcodedog05]

Hi @suds144 

If attending people is more than total should we round it off to 100 or what should we do?

[suds144]

I think it's more what should we do to? I welcome any thoughts and opinions.

[suds144]

Maybe rounding to 100 would work?

[atcodedog05]

Hi @suds144 

What you should do is totally dependent on the business requirement. If you want to round it 100. Here is how you can do.

Workflow:

Hope this helps : )