How to increment number based on the previous value

[akanchar]

Hi Team, 

I am looking for a solution in Alteryx designer. I want to increment the value in ID column based on the available number. can someone please advise?

Input 

Customer	ID
C1	28
C2
C3
C4
C5

Required Output

Customer	ID
C1	28
C2	29
C3	30
C4	31
C5	32

[Luke_C · Accepted solution]

Hi @akanchar 

You could use a multi-row formula tool. See below, if the ID field is blank it looks to the previous row's value and adds 1. 

[akanchar]

This worked. Thank you