How to dynamically replace a value with another value that changes annually

jberistain

Example: 

FiscalYear

  FY22

  FY23

I used a formula tool to add a column for a numeric value 

ToNumber(Right([Fiscal Year], 2))

Fiscal Year   Year

  FY22            22

  FY23            23

I want to now add a column to replace "FY22" and "FY23" with "FYPrev" & "FYCurr" so I can ultimately replace them in my main data stream so when I crosstab the data (and a few other steps) I have two columns named "FYPrev_Actual" & "FYCurr_Actual" instead of "FY22_Actual" & "FY23_Actual" so I don't have to go back each year to select the new rows to cross tab.

PanPP

Hi @jberistain 

I have provided a sample WF that creates FYPrev/FYCurr and FYPrev_Actual/FYCurr_Actual columns. 

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.

Sample WF - Fiscal Year.yxmd