I have a data-set where I'm trying to create a running total based on a set of criteria(sample attached).
For each grouping of columns A-E, sum [STATUS_LENGTH_DAYS_c] from that row down if [EXP_DT] is within 365 days of that row's [EXP_DT] . Looking at the formula's in the attached spreadsheet makes more sense than a way I can explain it through text.
For example: The first row has an [EXP_DT] of 2024-12-31. The [RunningTotal_12MonthsBack] field would sum all [STATUS_LENGTH_DAYS_c] where all [EXP_DT] is between 2024-12-31 and 2024-01-01 for that aggregated grouping of columns A-E. The expected results are in column J.
The colored bar show the first 3 Results and the range of the calcs as a sample.
Thanks for any help!!
-Craig
Solved! Go to Solution.
Multi-Row Formula Tool is not going to work for you in this case. The Generate Rows Tool, however, will generate all valid dates for this problem, that you can add a Join criteria prior to a Summarize Tool that will sum up the [STATUS_LENGTH_DAYS] field:
