D
downhillsheep
Ok, I'm sure this is pretty easy to figure out but this has been buggin
me for a while.
If you look at the list below, I have twelve months of data of variou
amounts. What I would like to do is to report ZERO for Jan as the amoun
if less than 0.5; report ZERO for Feb as the total of Jan and Feb i
still less than 0.5. However, for Mar I'd like to report 0.7 as that i
the total of Jan, Feb, and Mar and is over 0.5. For Apr I would like t
report 1.2 as that amount is already higher than 0.5; May ZERO and Ju
1.3 and so on and so fourth
Jan Feb Mar Apr May Jun Jul
Data 0.2 0.1 0.4 1.2 0.3 1.0 0.2
What I'd 0.0 0.0 0.7 1.2 0.0 1.3 0.0 like to
achieve
I have to do this for over 10k lines of data and would love an easie
way of formulating it so I know what needs to be reported on any give
month
Thank you so much for your hel
me for a while.
If you look at the list below, I have twelve months of data of variou
amounts. What I would like to do is to report ZERO for Jan as the amoun
if less than 0.5; report ZERO for Feb as the total of Jan and Feb i
still less than 0.5. However, for Mar I'd like to report 0.7 as that i
the total of Jan, Feb, and Mar and is over 0.5. For Apr I would like t
report 1.2 as that amount is already higher than 0.5; May ZERO and Ju
1.3 and so on and so fourth
Jan Feb Mar Apr May Jun Jul
Data 0.2 0.1 0.4 1.2 0.3 1.0 0.2
What I'd 0.0 0.0 0.7 1.2 0.0 1.3 0.0 like to
achieve
I have to do this for over 10k lines of data and would love an easie
way of formulating it so I know what needs to be reported on any give
month
Thank you so much for your hel