Question with average

[Edu_XGomes]

Hi Guys,

Can you please help me with a task I have to solve about average but I have no idea how to do it.

What I have here is that I have to put data into some empty fields in order to get the data in the same levels throw months.

I attached a spreadsheet but in short what I have to get would be:

if month 1 = 10 and other months empty so I would to get 10 to all months so I used max([variable1] ...[variable6]) So everything was ok here...

But if I have two or more values I would have to get the average from these values and fill the empty fields....

Can you please help me with this?

Thanks a ton

[JosephSerpis · Accepted solution]

Hi @Edu_XGomes I mocked up a workflow that I think produces the output you describe. Let me know what you think?

[Edu_XGomes · Accepted solution]

Great JS420!

Now everything is running as well here.

Thanks!