Alteryx designer Discussions

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

Substract formula

Highlighted
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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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.

Labels