Percentage change from old to new value with respective to unique criteria

[vinodbombale]

Hello,

I am looking for workflow solution to find out percentage change in prices in my data set. 

In sample file column "Country"+ "Local Code" is unique criteria for my data set. 

Condition is : if Country  and local code in current row is same for Current row +1 then calculate percentage difference current row price and current row +1 price. if if Country  and local code in current row is not same for Current row +1 then percent change in price will be "-".

Sample file has formulae for reference, last two column is expected outcome.

Thanks in advance

[OllieClarke · Accepted solution]

Hi @vinodbombale 

I think this does the trick (note that both multi-row formulas are grouped by Country and Local Code)

[apathetichell]

"-" is a string - not a number so you can't have it a  numeric field. Currently I'm using a null() but I could use a zero.  This matches the numeric values of what you are looking for.

[Sree_analytics]

I am new to alteryx tool and trying to build a report which shows me the current day % increase in transaction volume compared to last 6 days. Which is similar to this case. So posting it here.

Also, there is bifurcation by a 6 digit code and Merchant name. My data looks like the below:

Code    | Merchant Name | 4-Jul | 5-Jul | 6-Jul |7-Jul |8-Jul |9-Jul |10-Jul |% Increase

123456 | ABCD                 |  0     | 0       | 0       | 40    |  80   | 100  | 200   | sum(4 to 9th Jul volume)/ 10 Jul volume

% Increase i.e.(0+0+0+40+80+100)/200

Appreciate any help and if possible a sample workflow would be great

[#5]

I am new to alteryx tool and trying to build a report which shows me the current day % increase in transaction volume compared to last 6 days. Which is similar to this case. So posting it here.

Also, there is bifurcation by a 6 digit code and Merchant name. My data looks like the below:

Code    | Merchant Name | 4-Jul | 5-Jul | 6-Jul |7-Jul |8-Jul |9-Jul |10-Jul |% Increase

123456 | ABCD                 |  0     | 0       | 0       | 40    |  80   | 100  | 200   | sum(4 to 9th Jul volume)/ 10 Jul volume

% Increase i.e.(0+0+0+40+80+100)/200

Appreciate any help and if possible a sample workflow would be great