You don’t need a cross join. Just use window functions: SELECT P.PersonID, SUM(PA.Total), SUM(PA.Total) * 100.0 / SUM(SUM(PA.Total)) OVER () AS Percentage FROM Person P JOIN Package PA ON P.PersonID = PA.PackageFK GROUP BY P.PersonID; Note that you do not need the JOIN for this query: SELECT PA.PersonID, SUM(PA.Total), SUM(PA.Total) * 100.0 / SUM(SUM(PA.Total)) OVER … Read more
try this SELECT group_name, employees, surveys, COUNT( surveys ) AS test1, concat(round(( surveys/employees * 100 ),2),’%’) AS percentage FROM a_test GROUP BY employees DEMO HERE
To print the % sign you need to ‘escape’ it with another % sign: percent = 12 print “Percentage: %s %%\n” % percent # Note the double % sign >>> Percentage: 12 % EDIT Nowadays in python3 a better (and more readable) approach is to use f-strings. Note that other solutions (shown below) do work … Read more
Your problem is that you have to change: printf(“%”); to printf(“%%”); Or you could use ASCII code and write: printf(“%c”, 37); 🙂
Use value_counts with normalize=True: df[‘gender’].value_counts(normalize=True) * 100 The result is a fraction in range (0, 1]. We multiply by 100 here in order to get the %.
In version 5 of videojs you can use vjs-16-9 vjs-4-3 class on video object, <video class=”video-js vjs-default-skin vjs-16-9″ …> … </video> or use fluid option <video class=”video-js vjs-default-skin” data-setup='{“fluid”: true}’ …> … </video> Source: https://coolestguidesontheplanet.com/videodrome/videojs/
You were very close with your df attempt. Try changing: df[‘col’] = df[‘col’].astype(float) to: df[‘col’] = df[‘col’].str.rstrip(‘%’).astype(‘float’) / 100.0 # ^ use str funcs to elim ‘%’ ^ divide by 100 # could also be: .str[:-1].astype(… Pandas supports Python’s string processing functions on string columns. Just precede the string function you want with .str and … Read more
I have found out that spread size of shadow can’t be set to percentage of parent object True. But you can set font-size on the parent object, then define the object size in ems, and use the same ems to define the box-shadow size. Or, if your parent object happens to be the window, you … Read more
In SQL Server 2012 and later, there is the FORMAT() function. You can pass it a ‘P’ parameter for percentage. For example: SELECT FORMAT((37.0/38.0),’P’) as [Percentage] — 97.37 % To support percentage decimal precision, you can use P0 for no decimals (whole-numbers) or P3 for 3 decimals (97.368%). SELECT FORMAT((37.0/38.0),’P0′) as [WholeNumberPercentage] — 97 % … Read more