Tiaguinho Posted October 27, 2015 Share 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? Link to comment Share on other sites More sharing options...
Sukanya Parisa Posted October 29, 2015 Share Posted October 29, 2015 check the running sum concepts in sql, it may helpful Link to comment Share on other sites More sharing options...
Tiaguinho Posted October 29, 2015 Author Share 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. :) Link to comment Share on other sites More sharing options...
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