How to create a formula with iterations / sequences

  • 5 September 2022
  • 1 reply

I would like to adapt in Pigment a simple formula used in excel (Metric 1 in yellow, with details in cell F2) :

NB : The grey cell C2 is a manual input initiating the sequence.

Issue: as the calculation is like a sequence using each previous value, there would be iterations within the same metric.

I’ve tried the below formula to overcome the issue, it works for few months but you can see it’s not scalable: 



Best answer by Nathan 5 September 2022, 15:11

View original

1 reply

Userlevel 6
Badge +12

Hi Muriel,


You can read my post that explains how to use previous() to do just this:

Previous value & Circular Reference | Community (