good evening,
I would like to be able, based on the month I am in, to feed the columns of the following months, based on how long a contract lasts.
ex:
it’s January, I have 3 months of contract and each month is worth 100, I would like it to feed the February, March and April column with 100.
another contract is worth 200 each month, and the contract expires in 5 months, so I need to feed equal amounts from February to June.
is there any way? i have created columns with value 1 with all the months i don’t know if it will help.