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:)
