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

Substract formula

Raj_2
8 - Asteroid

Hi Alter,

 

I request your help on below, I have two rows with Jan to Dec sales data where I need to subtract row 2 to row 3. I tried multi field formula but not getting it correct in the new field , need a help. For for Jan I expect 486846-10444

 

 

              Jan    Feb        March   April.....

1 22879 [Null] [Null] [Null] [Null] [Null] [Null] [Null] [Null] [Null] [Null] [Null] [Null]
2 [Null] 10444 43554.52 10497 11505 10338 10419 10272 10382 10626 9834 50669.43 10942
3 [Null] 486846 3593022.19 453633 472650 497908 544328 864424 570534 609392 1125123 5691044.72 536187

2 REPLIES 2
CharlieS
17 - Castor
17 - Castor

I approached this by transforming the data a little to make the calculation a bit easier. Check out the attached solution and let me know what you think.

Steph
6 - Meteoroid

Was able to use this as well. Thank you! 😊

Labels