Sfrgttk

15% tax on $7.5k earnings. Is that right?

Change the color of a single dot in `ddot` symbol

How do I fix the group tension caused by my character stealing and possibly killing without provocation?

Which was the first story featuring espers?

Can I cause damage to electrical appliances by unplugging them when they are turned on?

Why does Carol not get rid of the Kree symbol on her suit when she changes its colours?

What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?

Why does AES have exactly 10 rounds for a 128-bit key, 12 for 192 bits and 14 for a 256-bit key size?

How do I tell my boss that I'm quitting soon, especially given that a colleague just left this week

Make a Bowl of Alphabet Soup

US tourist/student visa

Quoting Keynes in a lecture

Is there any evidence that Cleopatra and Caesarion considered fleeing to India to escape the Romans?

Is this toilet slogan correct usage of the English language?

What is Cash Advance APR?

Why is it that I can sometimes guess the next note?

Mimic lecturing on blackboard, facing audience

Giving feedback to someone without sounding prejudiced

How to get directions in deep space?

Does "he squandered his car on drink" sound natural?

A variation to the phrase "hanging over my shoulders"

What's the name of the logical fallacy where a debater extends a statement far beyond the original statement to make it true?

Why do Radio Buttons not fill the entire outer circle?

Why can't the Brexit deadlock in the UK parliament be solved with a plurality vote?

I have a beginning balance I need to calculate ending balance running total by month rows

0

I have been searching this site and others trying to find an answer to this. I tried various things but cannot get my head around an answer so here goes.
Here my data:

What I need is to start with the begbal of each Acct and add the debits, subtract the credits and produce an ending balance of that month (row). When the Acct changes, pick up the new begbal and start again. With the data it should look like this:

I can get a running total on the debits and credits by doing this:

SELECT

pph.Acct,

pph.Year,

pph.Prd,

pph.begbal

pph.debit,

pph.credit,

SUM(pph.debit+pph.credit) OVER (PARTITION BY pph.Acct ORDER BY pph.Year, pph.Prd) AS endbal

FROM GL_PeriodPostingHistory pph

What I want to do is

If Acct <> prevoius Acct

then Sum( begbal+debit-credit)

else Sum(previous endbal+debit-credit) as endbal

and I just can't figure out how.

Thank you for consideration,

Clare

sql-server-2014 running-totals

share

asked 3 mins ago

C.SmithC.Smith

1

New contributor

C.Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I have been searching this site and others trying to find an answer to this. I tried various things but cannot get my head around an answer so here goes.
Here my data:

What I need is to start with the begbal of each Acct and add the debits, subtract the credits and produce an ending balance of that month (row). When the Acct changes, pick up the new begbal and start again. With the data it should look like this:

I can get a running total on the debits and credits by doing this:

SELECT

pph.Acct,

pph.Year,

pph.Prd,

pph.begbal

pph.debit,

pph.credit,

SUM(pph.debit+pph.credit) OVER (PARTITION BY pph.Acct ORDER BY pph.Year, pph.Prd) AS endbal

FROM GL_PeriodPostingHistory pph

What I want to do is

If Acct <> prevoius Acct

then Sum( begbal+debit-credit)

else Sum(previous endbal+debit-credit) as endbal

and I just can't figure out how.

Thank you for consideration,

Clare

sql-server-2014 running-totals

share

asked 3 mins ago

C.SmithC.Smith

1

New contributor

C.Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I have been searching this site and others trying to find an answer to this. I tried various things but cannot get my head around an answer so here goes.
Here my data:

What I need is to start with the begbal of each Acct and add the debits, subtract the credits and produce an ending balance of that month (row). When the Acct changes, pick up the new begbal and start again. With the data it should look like this:

I can get a running total on the debits and credits by doing this:

SELECT

pph.Acct,

pph.Year,

pph.Prd,

pph.begbal

pph.debit,

pph.credit,

SUM(pph.debit+pph.credit) OVER (PARTITION BY pph.Acct ORDER BY pph.Year, pph.Prd) AS endbal

FROM GL_PeriodPostingHistory pph

What I want to do is

If Acct <> prevoius Acct

then Sum( begbal+debit-credit)

else Sum(previous endbal+debit-credit) as endbal

and I just can't figure out how.

Thank you for consideration,

Clare

sql-server-2014 running-totals

share

asked 3 mins ago

C.SmithC.Smith

1

New contributor

C.Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 3 mins ago

C.SmithC.Smith

1

New contributor

C.Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 3 mins ago

C.SmithC.Smith

1

New contributor

C.Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 3 mins ago

C.SmithC.Smith

1

New contributor

C.Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 3 mins ago

C.SmithC.Smith

1