Datatellsall2
New Member
- Joined
- Jul 17, 2018
- Messages
- 23
Hello,
I'm trying to calculate the cumulative sum of time value (before, during, and after day of call) - see the last 3 columns. I've filled in the correct amounts below as a reference for the last 3 columns. What would be the best formula to calculate this? Essentially, my formula needs to look at any information prior to the day of call ("yes" or "no"), as well as post "yes". Please note that I must take into consideration the Unique Identifier, as I have roughly 400 different ones in my full data set.
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Unique Identifier
[/TD]
[TD]Date[/TD]
[TD]Time Value[/TD]
[TD]Day of Call?[/TD]
[TD]Cumulative Sum of Time Value (Before Call)[/TD]
[TD]Cumulative Sum of Time Value (Day of Call)[/TD]
[TD]Cumulative Sum of Time Value (After Call)[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/1/2018[/TD]
[TD]3[/TD]
[TD]No[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/2/2018[/TD]
[TD]3[/TD]
[TD]No[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/3/2018[/TD]
[TD]3[/TD]
[TD]No[/TD]
[TD]9[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/4/2018[/TD]
[TD]2[/TD]
[TD]Yes[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/5/2018[/TD]
[TD]4[/TD]
[TD]No[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/6/2018[/TD]
[TD]6[/TD]
[TD]No[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance,
M
I'm trying to calculate the cumulative sum of time value (before, during, and after day of call) - see the last 3 columns. I've filled in the correct amounts below as a reference for the last 3 columns. What would be the best formula to calculate this? Essentially, my formula needs to look at any information prior to the day of call ("yes" or "no"), as well as post "yes". Please note that I must take into consideration the Unique Identifier, as I have roughly 400 different ones in my full data set.
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Unique Identifier
[/TD]
[TD]Date[/TD]
[TD]Time Value[/TD]
[TD]Day of Call?[/TD]
[TD]Cumulative Sum of Time Value (Before Call)[/TD]
[TD]Cumulative Sum of Time Value (Day of Call)[/TD]
[TD]Cumulative Sum of Time Value (After Call)[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/1/2018[/TD]
[TD]3[/TD]
[TD]No[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/2/2018[/TD]
[TD]3[/TD]
[TD]No[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/3/2018[/TD]
[TD]3[/TD]
[TD]No[/TD]
[TD]9[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/4/2018[/TD]
[TD]2[/TD]
[TD]Yes[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/5/2018[/TD]
[TD]4[/TD]
[TD]No[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]8/6/2018[/TD]
[TD]6[/TD]
[TD]No[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance,
M