Calculating Running Difference Total (Row:ColA - Row-1:ColC) till it is positive

Question

Hi Team

I hope you all are doing good!

I am stuck somewhere and need your help.

I wish to achieve a kind of calculating Running Difference Total (Row:ColA - Row-1:ColC) till the time the result of  this difference (Row:ColA - Row-1:ColC) is positive.

Sample data attached which has formulas in excel with which I have achieved it. Please advise how can we achieve this in Alteryx Designer?

Sample Data.xlsx

AngelosPachis · Accepted Answer

Hi @Tej_Singh ,

Can you try this expression in your multi-row formula tool please?

IF ISNULL([Row-1:BUY]) THEN [BUY]-[DIFF]
ELSEIF [Row-1:Buy-Diff]<0 THEN [BUY]-ABS([Row-1:Buy-Diff])
ELSE [BUY] 
ENDIF

Hope that helps,

Angelos