Percentage of Total

[ntudev]

How do i get the percentage of total like the below, i'm just interested in what is the percentage of total per Date. please help!

Date	Critical	Total Value	percentage of total
2/28/2023	Critical	$     2,703,290,154.37	26%
2/28/2023	Not Critical	$     7,554,224,205.45	74%
1/31/2023	Critical	$        703,290,154.37	8%
1/31/2023	Not Critical	$     8,554,224,205.45	92%

[DataNath]

Hey @ntudev, here's how I'd go about this:

1) Create a new, numeric version of the [Total Value] column so we can work with it as needed

2) Use a Summarize tool to create a sum of this [Total Value], grouped by [Date]

3) Join this total back to the relevant [Date]

4) Divide [Total Value] by the relevant sum, multiplying by 100 and converting to a string to add the '%' sign

5) Clean-up fields that were made temporarily to get to the solution

Hope this helps!

[PhilipMannering]

Hi @ntudev,

How about this?

[ntudev]

this works but i am trying to get the full decimals like the below, right not its just giving me 0% how do i change it to the below?

750,000,000.00	89,990,042,740.48	0.008334
450,000,000.00	89,990,042,740.48	0.005001
475,000,000.00	89,990,042,740.48	0.005278
500,000,000.00	89,990,042,740.48	0.005556

[caltang]

Another way to do it:

[DataNath]

Hey @ntudev, that will be the Round() doing that as it's to the nearest whole number. If you remove that it should work: