I have the following scenario :
Date A B
2016-03-01 y y
2016-03-02 x B(yesterday) + x
Bascially, I am trying to do addition in column B on monthly basis.
B(today) = A(today) + B(yesterday)
I am trying to execute this calculation :
DAY(`Date`) = 1 then
??? -> How do I get yesterday's value of B ?
Also, please note that I cannot use CURRENT_DATE() for any manipulation as I am trying to calculate for already existing data as well