If seems like the basic idea of the 'YEAR' field is determined by the 'PAY ELEMENT' field begins with "FY". If it does begin with "FY", take the first 4 characters. When it does not, should you take the year from the previous row? What if the first row of 'PAY ELEMENT' doesn't begin with "FY"?
Anyways, I've attached a quick example using a Multi-Row Formula tool.
Thank you
Hello there,
is there a way to add "FTE" & "CURRENT_BASE" to every year? it is basically what you asked before (What if the first row of 'PAY ELEMENT' doesn't begin with "FY"?)
Please advise. Thank you in advance!!
