Tiaguinho Posted October 27, 2015 Posted October 27, 2015 Hello,I own a report with grouping by date, and with a summation by date. I need the sum of the previous date for the calculation of the next date.But have not found a way to busar the previous value, I tried to create a new variable, but the same always updated with the current value date of the group.Could anyone help me?
Sukanya Parisa Posted October 29, 2015 Posted October 29, 2015 check the running sum concepts in sql, it may helpful
Tiaguinho Posted October 29, 2015 Author Posted October 29, 2015 Yes. I resolve this problem in the sql. The SQL retrieve all data and after calculate value.thanks for the answer. :)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now