Repeat Values in all rows

[JonaV]

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!

[Qiu]

@JonaV 

Something like this?

[mot]

Hi @JonaV,

This is one way to do it:

I hope this helps. Best!

[JonaV]

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)

[pedrodrfaria]

Hi @JonaV 

Is this what you are looking for?

Pedro

[JonaV]

Doesn't look like it.

I want the "Sum_Total Empl" numbers for the first 10 records to show in the next 10 records.+

So, I want the 2017 Year End numbers (Dec) to show in 2018, the 2018 show in 2019 and so forth - for every month I want the Prior Year DEC numbers to show. The DEC numbers are my baseline for the calculation for every single month for every single record

Hope that makes sense

[mot]

Hi @JonaV,

I have a better understanding of your goal now. Please check the attached workflow. Best!