I need to view a report between two dates and using parameters in my query does not work because I have a running sum.
Ex.: start value=100; total for day1 =30; end of day1 =100+30; total for day2 = 17; end of day2 =130+17; total for day3=2; end of day3=147+2 etc. Obviously, end of day3 is correct only if I start from the beginning.
I have tried until now to "filter" only the dates in the report (where condition) but I begin to have doubts that this is the path to take .
I feel like there must be another solution but I can't see it . Can someone point me in the right direction?
Ex.: start value=100; total for day1 =30; end of day1 =100+30; total for day2 = 17; end of day2 =130+17; total for day3=2; end of day3=147+2 etc. Obviously, end of day3 is correct only if I start from the beginning.
I have tried until now to "filter" only the dates in the report (where condition) but I begin to have doubts that this is the path to take .
I feel like there must be another solution but I can't see it . Can someone point me in the right direction?