Custom Column to work out the Percentage of another column

[Rogerh]

Hello,

Can I please have some help on a custom column? I have read posts simular to mine but I am unable to get it to work.

I have a table for days of the week, (Mon to Sun), I used a custom column to count the total amount of orders per weekday from another table. I would like the next column to show what percentage of orders we get on what day of the week but I am unable to work out how to do it.

This is my current table, the last column is what I would like it to show. Can I please have some assistance with the code?

Week Day	Index	Orders	Percentage of orders over a week
Mon	1	6042	16.83%
Tue	2	5857	16.32%
Wed	3	5398	15.04%
Thu	4	5332	14.86%
Fri	5	5272	14.69%
Sat	6	3827	10.66%
Sun	7	4162	11.60%

I need the data in a table to be able to use it the way I want to later.

Thank you in advance for any assistance.

[amitchandak · Accepted solution]

@Rogerh , if need a column.

new column = divide([Orders], sum([Orders]))

[Rogerh]

Thank you @amitchandak