Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to reverse amortize sales based on gains and losses?

sheidari
8 - Asteroid

I have a set of data that includes sales, and gains/losses but i want to adjust the sales based on the gains/losses in order to smooth out spikes and dips in my monthly sales #s. 

 

Been trying to use a multi-row tool to amortize it but it's not working as i want.  Below is the original sample data and the expected output:

 

sheidari_0-1620132856233.png

 

Any help would be greatly appreciated!

2 REPLIES 2
Luke_C
17 - Castor

Hi @sheidari 

 

Here's one approach:

 

  1. Add record ID, reverse by sorting
  2. Multi-row to fill in gain/loss of 3M for every record (Multi-row is great for filling down, not so much filling up)
  3. Sort back and perform the calculation. My numbers are off by 5 which I assume is because your %s have more numbers than are visible. 

Let me know if this works for you

 

 

Luke_C_0-1620134724297.png

 

sheidari
8 - Asteroid

@Luke_C Thanks for the help. This did the trick!

Labels