Percentage of Total

Question

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!

DateCriticalTotal Valuepercentage of total2/28/2023Critical $     2,703,290,154.3726%2/28/2023Not Critical $     7,554,224,205.4574%1/31/2023Critical $        703,290,154.378%1/31/2023Not Critical $     8,554,224,205.4592%

DataNath · Answer

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

Calculate pct of total per date.yxmd

caltang · Answer

Another way to do it:

For ntudev2.yxmd

ntudev · Answer

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.480.008334    450,000,000.00    89,990,042,740.480.005001    475,000,000.00    89,990,042,740.480.005278    500,000,000.00    89,990,042,740.480.005556