I am looking on how to populate numbers sequentially.
I have the following table below with 3 clients. If a client first meets a condition, it gets a primary flag of "1". (highlight in yellow below). So for Client A, first "!" is Mar 18, for B its Jan 18 and for C is Apr 18.
I want to create a field in the backend, where the subsequent months gets a cumulative number and preceding months will be negative. So solution I'm looking for is Column "Answer" in the table below.