Populating Numbers

[KamenRider]

Hi Alteryx Community,

I am seeking your help in filling in the numbers, irrespective of the number of rejects and dates. I've tried using the multi-row formula with the expression "IF ISNULL([Value]) THEN [Row-1:Value] ELSE [Value] ENDIF", but it isn't populating as expected. Your assistance would be greatly appreciated.

Sample:

 

Results should be:

 

Thanks in advance,

Kamen

[abacon · Accepted solution]

@KamenRider Here is a way to do it. It doesn't use the Multi-Row formula, but uses the Transpose/Cross-tab functionality to rearrange the data then split out to rows.

Bacon

[binuacs · Accepted solution]

@KamenRider one way of doing this

[KamenRider · Accepted solution]

Hi @binuacs 

Thanks for the solution. I somewhat revised the workflow to show the date as header.

 

Kamen

[KamenRider]

Hi @abacon 

Thank you so much for this solution. This also works.

Kamen