Hi, I have a question on a potential metric. It is very complicated, basically in order to get the value for the next date you need to take the value for the previous date, multiply that by a different number, and then add a different number. There is no way to get the value without knowing the previous date’s value. Is there a formula I can use for this? I don’t think any simple sum or product works here.

Hi Andy, to make sure I understand correctly, is your calculation similar to this? Let's say we want to calculate a 'cumulative value' where each day's value is the previous day's value multiplied by 2, then plus 1. So, if the first day's value is 5, the next day would be (5 * 2) + 1 = 11, and the day after that would be (11 * 2) + 1 = 23. Also, a crucial detail for us to understand is whether the 'multiplicative number' and 'additive number' are constant values that stay the same for every date, or if they change from date to date. OR are taking from a 'column'? Could you please clarify this? Is this the general concept you're working with?

Thanks very much Mauricio. Yes that is exactly the general concept I’m working with. The “multiplicative number” and the “additive number” are actually both other metrics and those metrics do change from day to day.

Hi Andy, unfortunately you are right, if the multiplicative and additive number are not constant, there is no way to know the value 'today' if you dont know the value for yesterday.

Ok, thanks