Hi Guys, I want to accumulate a value of a c...

(KVG Gaming) #1

Hi Guys,

I want to accumulate a value of a column monthly by 1.25. anyone knows how?

Thanks

(Bellave Jayaram) #2

You can try with scheduled workflow. A script is another alternative.

(Aleksi Alkio) #3

Would you please describe your request little more. I couldn’t get the point. Where do you want to accumulate the value? In virtual column, workflow, where?

(KVG Gaming) #4

@Aleksi_Alkio on a column I wanted that the value of that to accumulate every start of the month and become 0 on last day of the year

(Aleksi Alkio) #5

So… you want 1.25, when the date is 1/1/2018, 2.50 2/1/2018 etc.?

(KVG Gaming) #6

@Aleksi_Alkio yes but after it accumulate on the dec 1. On the dec 31 it will became 0

(KVG Gaming) #7

@Aleksi_Alkio should i go for if now is equals to feb 1 then value is equal to value +1.25 then etc. Then on the on the 31 of dec value is equals to zero. Can i do that script with the year? Only looking at the mm and dd. Sorry noob on script here

(Aleksi Alkio) #8

So… 1/1 - 0 2/1 - 1.25 3/1 - 2.5 4/1 - 3.75 5/1 - 5 6/1 - 6.25 7/1 - 7.5 8/1 - 8.75 9/1 - 10 10/1 - 11.25 11/1 - 12.5 12/1 - 13.75 12/31 - reset to 0 Is this correct?

(KVG Gaming) #9

@Aleksi_Alkio Cell A1 = 0 ever first day of the month it will add 1.25 then on the 12/31 it will go back to 0

(Aleksi Alkio) #10

So… is my table then correct as I wrote above?