How to add a new calculated column

Ramon Quintana

7y842

HI,

I want to add and an acumulative values in a new “Accumulative” Column from SUMA_PROFIT column, begins from last record.

for example:

last record value 1714703269481.14 + penultimate record value 1228973052365.97 and so...

Do i explained well??

Thank u MATES

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramon Quintana7y ago
Hi Amit,

That is a good Clause, but it works to get Sub-Totals only, What I want is to know how to get a Accumulative column.

I have been trying with this:

sum(Query_Base.profit_center_local_currency)
OVER (PARTITION BY Query_Base.Cuentas_Maestro_Numero_cuenta,Query_Base.Fiscal_Year--,Query_Base.Period
ORDER BY Query_Base.Cuentas_Maestro_Numero_cuenta,Query_Base.Fiscal_Year,Query_Base.Period
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS Acumulado

It seen to works fine, but if you know some else clause please let me it know.

Really Thank u..
+1
Amit Kumar7y ago
Hi, you can use calculate total using Group by and rollup. See the below link it is running. https://www.dotnettechpoint.com/2018/03/calculate-final-total-in-sql-server.html?m=1
+2
Bidyasagar Mishra7y ago
Hi Ramon,
Follow the below link
https://dba.stackexchange.com/questions/181773/sum-of-previous-n-number-of-columns-based-on-some-category
+2
Ramon Quintana7y ago
Hi,

Just i want to create a new column from sum accumulative values begins from last record

For example:

1963362209725.44 + 1565215511404.92 + etc Until first record´s table

0
Bidyasagar Mishra7y ago
can you describe more ?
+1