Hint on calculation

Gustavo Camacho

Any ideas on how to do this type of calculation in a dataflow

where C2 and D2 and so on are calculated from previous month from row 5.

I can only get it to work if i calculated each month in a loop, but there must be another way?

Leone Scaburri

Hello @Gustavo Camacho,

the "Period by period recursion" option on dataflow is what you are looking forward.

The new “Period by Period recursion” checkbox allows to use the result of the calculation on the first period as the source for the calculation on the next period.

https://www.boardmanual.com/2021/summer/whats-new-release-notes/spring-2021-release/Main_features/Data_Flow.htm#period-by-period

Leone Scaburri

Check out this practical example from our How-To section

https://community.board.com/discussion/17446/how-to-use-period-by-period-recursion