Forum Discussion
Anonymous
2 years agoNot applicable
Cumulative Column But only adding if previous row was negative
Hi All, I'm trying to create a calc column that is cummulative but only with negative values. Ive tried a bunch of solutions but havent had much luck so any help is appreciated! This is my co...
Ahmedx
Super User
2 years agowhat result do you expect?
Anonymous
2 years agoNot applicable
Effectivly what I showed in the table, im creating this to find expected expiry stock. so for each date period any positive values(expired stock) would not be added to the next date but any negative values(remaining consumption) would be added to the calculation of next dates expired stock. The issue is it should really only be factoring whatever the previous date expired stock would be in calculating the current dates expired stock.