In my table MyTable I have a column which contains 8 digit numeric value.
(ie)
Data
20151201
20151204
20181208
20181219
My requirement is I need a new column named Sum and the data should be sum of MyColumn values with below formula.
Data SumColumn
20151201 3
20151204 6
20181208 4
20181219 6
Formula is
For Example
20181219
(2+0+1+8) + (1+2) + (1+9)
(11) + (3) + (10)
(1+1) + (3) + (1+0)
(2) + (3) +(1)
(6)