declare a constant to first row followed by cumulative difference

[SrinivasanSugumaran]

hi everyone .. can you pls. help me in getting the output col. in the below table in alteryx.

limit for first row of output col is 1000( user defined). I have already added a constant in workflow tab for this and the subsequent rows should be a cumulative difference.

id	salary	output col	logic
1	100	1000	user defined constant -1000
2	200	900	1000-100
3	300	700	900-200
4	400	400	700-300

[jdunkerley79]

Hi,

I think a multi-row formula tool will do what you need. Something like:

IIF(IsNull([Row-1:Output]),[User.Initial],[Row-1:Output])-[salary]

Alternatively, you could use a running total and then a formula tool to add the value. 

Hope it helps

[atcodedog05 · Accepted solution]

Hi @SrinivasanSugumaran ,

I think what you are looking for is an app where user can give a value during runtime.

Here is the input.

App

Output

Workflow

Hope i am close to what you are looking for.

Hope this helps : )

If this helps please mark the post as solution.