Calculating values from N number of columns
I have a dataset which contains Keys, some additional important data I'd need to keep and then 12 columns of values (Value (M1), Value (M2), Value (M3) etc.).
Depending on how many months we have left in the year at the time, I have to add N number of columns together (right now, we have October November and December left, so I would need M1-2-3 added together, but say in June, I'd need to add M1-to-6 added together.)
Is there any way to solve this? (using 2.8.8 at the moment)
Thanks in advance.