Calculating current period data based on prior period variable

[DominicT23]

I am trying to recreate this formula within Alteryx. The formula calculates the current period data in BW utilizing the same period data from column BX and Prior period data from column BW over a multiple period time span. 

[vizAlter]

Hi @DominicT23 — Welcome to the Alteryx Discussions!

Suggest you to attached (1) the file for input along with formulas, and (2) desired output layout

[AkimasaKajitani]

You can use Multi-row formula.

Expression:

IF NOT IsNull([Row-1:New Field]) THEN [Row-1:New Field]*[a] ELSE [a] ENDIF