Return previous value of the group
Posted on October 27, 2015 at 10:17am
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?
Joined: Feb 26 2014 - 4:06am
Last seen: 4 years 1 month ago
Posted on October 29, 2015 at 3:11am
check the running sum concepts in sql, it may helpful
Joined: Dec 5 2013 - 10:29pm
Last seen: 6 years 6 months ago
Posted on October 29, 2015 at 6:12am
Yes. I resolve this problem in the sql. The SQL retrieve all data and after calculate value.
thanks for the answer. :)
Joined: Feb 26 2014 - 4:06am
Last seen: 4 years 1 month ago
