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.