Fill in the Blanks with closest data

[jenv20032000x]

Greetings Alteryx Users, I'm hoping you can help me.

I have been using the multi row formula tool with no success.  If the very first record is populated, I can use the -1row, but this is not always the case.  Data can be spread out further than 1 row and it can be forwards rather than backwards.  I've attached a simplistic view of my data but it illustrates my dilemma.  Maybe I'm using the wrong tool.  I eagerly await your input.

[MarqueeCrew]

@jenv20032000x ,

I think that I've solved the problem.  I find first value (not null) and use it when prior row is null.

Cheers,

Mark

Ps the older version version will open with any AYX designer

[atcodedog05]

Hi @jenv20032000x 

You would need to do bottom-up and up to bottom fill up like below.

Workflow:

Hope this helps : )

[binay2448]

Hope this will resolve your issue..

[jenv20032000x]

Thank you for your reply binay2448.  While your solution gets me closer to the desired result, it is off when the product or customer changes.  In the desired output at row 9 is 1.5 and that carries forward through rows 10-12.  This is because the customer and product is the same.

[binay2448 · Accepted solution]

Find attached updated solution as requested

[atcodedog05]

Hi @jenv20032000x 

You can give my solution also a try.

[jenv20032000x]

Thank you everyone for your solutions!  I greatly appreciate it.  I will be accepting binay2448's solution.