Populating Numbers

Question

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 Answer

@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

binu_acs · Accepted Answer

@KamenRider one way of doing this

KamenRider · Accepted Answer

Hi @binu_acs

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

Kamen