Forum Discussion
Sum in quarter
Hi everybody! It's my first time writing here :-) I would really appreciate your help to solve this issue. I have a table which contains these values: DAYS | Count of number of runs | Cumu...
For the first quarter: 29.67 is 89/3 and it is wrong
33.33 is the sum of run/installed base for each day
66.016 is the sum of run/installed base for each day, including the total from the previous quarter
parry2k : shall I add something else?
- parry2k
Super User
Anonymous would you mind sharing sample data in excel and get back to you, you are using running total and thats' why q2 includes q1 data and so forth so on.
Maybe I can do the trick by subtracting the value from the previous quarter in the formula?
Unluckily it is quite difficult for me to share the Excel, since it contains a lot of data, that I cannot share :-(- parry2k
Anonymous trying to see what we can do here, may be just get sample data of few quarters with minimum column, do you think that is possible?
