Reverse Sums

Hello,

I have table something like

num0N0N0N10N0N30N0N4

and I want to have the sums going backwards, so the output would look like

num8888777444

I’ve tried using reverse fills, reverse sums, ect.. but can’t get it quite right

anyone have any ideas?

Correction:

p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000; background-color: #ffffff}span.s1 {font-variant-ligatures: no-common-ligatures}

q)select reverse sums reverse num from t

num


8  

8  

8  

8  

7  

7  

7  

4  

4  

4  

On Friday, July 28, 2017 at 7:34:44 AM UTC-4, Roni Hoffman wrote:

Hello,

I have table something like

num0N0N0N10N0N30N0N4

and I want to have the sums going backwards, so the output would look like

num8888777444

I’ve tried using reverse fills, reverse sums, ect.. but can’t get it quite right

anyone have any ideas?

Thanks! yea was having issues with the first suggestion, this works perfectly.  Cheers.