Free for PREMIUM members
Select account, year, period, sum(case when amount > 0 then amount else 0 end) as DrAmt, sum(case when amount < 0 then amount else 0 end) as CrAmt from <your table name> group by account, year, period
Open in new window
Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!