Hi everyone,
Can someone help me figure out a way to repeat all the values in the "Sum_TotalEmpl" column for Dec into all the rows?
So what I want is to for example I want the 3,812 number to show in row 11 the same even though it is Apr
Thanks!
@JonaV
Something like this?
Hi @JonaV,
This is one way to do it:
I hope this helps. Best!
I've attached the Excel output file from my workflow.
So, essentially what I want to do is to repeat the "Sum_Total_Empl" for every record so that I can make a calc that takes the Ext Hires (excl Sep) and divides it by the PREVIOUS YEAR End total. For example, in row 12 I want the calculation in cell H12 to be 48/3812 (or E12/D12)
Hi @JonaV
Is this what you are looking for?
Pedro