Data Manipulation on monthly basis

[Polite123]

Hi Team,

I receive one input file on monthly basis which is used as input to my workflow.

For eg-- Suppose current month is March, I have data for Jan and Feb in input file. If column B is 0 then column C should be 0 in case of Jan and Feb month. But for March which is current month in this example,it is average values of Jan and Feb month even if column B is 0 as shown in below table.

So in short for current month if column B is 0 then also I should have values in column C.

The process continues for all months this way.

Can anyone please help in this case?

A	B	C
1-Jan	1	3
2-Jan	2	4
3-Jan	0	0
1-Feb	3	4
2-Feb	0	0
3-Feb	5	6
1-Mar	0	3.5
2-Mar	0	2
3-Mar	0	3

Thanks in advance:)

[Qiu]

@Polite123 
Perhaps it will better if you can give two larger datasets for sample intput and output?

Not sure why the column B for March has to be zero, while I understand the C column is average of Jan and Feb for conreponsding date,

[Polite123]

Hi,

Column B is filled only for previous months and not for current one.

Column is averge as you understood correctly

below is data set

A	B	C
January-	1456	181
January-	200	3
January-	328	13
January-	289	0
January-	2352	318
January-	420	55
January-	574	96
January-	272	60
January-	450	58
January-	1176	154
January-	2520	368
January-	1688	244
January-	1008	233
January-	2856	350
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
January-	0	0
February-	2082	233
February-	541	91
February-	102	66
February-	116	77
February-	122	143
February-	170	100
February-	74	77
February-	126	60
February-	813	224
February-	286	115
February-	98	69
February-	216	57
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
February-	0	0
March-	0	35
March-	0	35
March-	0	40
March-	0	24
March-	0	183
March-	0	21
March-	0	185
March-	0	79
March-	0	57
March-	0	102
March-	0	100
March-	0	160
March-	0	66
March-	0	12
March-	0	41
March-	0	49
March-	0	59
March-	0	139
March-	0	44
March-	0	6
March-	0	55
March-	0	43
March-	0	241
March-	0	35
March-	0	22
March-	0	69
March-	0	100
March-	0	79
March-	0	34
March-	0	45
March-	0	72
March-	0	135
March-	0	35
March-	0	40
March-	0	105
March-	0	37
March-	0	77
March-	0	325
March-	0	63
March-	0	296
March-	0	84
March-	0	154
March-	0	83
March-	0	93
March-	0	34
March-	0	82
March-	0	21
March-	0	40
March-	0	20
March-	0	11
March-	0	63
March-	0	56
March-	0	98
March-	0	68
March-	0	59
March-	0	105
March-	0	0
March-	0	0
March-	0	0
March-	0	56
March-	0	33
March-	0	62
March-	0	114
March-	0	214
March-	0	171
March-	0	361
March-	0	245
March-	0	218
March-	0	353
March-	0	20
March-	0	142
March-	0	291
March-	0	320
March-	0	242
March-	0	21
March-	0	49
March-	0	63
March-	0	36
March-	0	63
March-	0	0
March-	0	277
March-	0	142
March-	0	96
March-	0	163
March-	0	42
March-	0	99
March-	0	112
March-	0	67
March-	0	57

Thanks:)