Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

How to deduct one total from another tolal

Carol_Chiu
6 - Meteoroid

At the end of my workflow, I have produced two totals.

How do I take the first total and minus the second total and then give me the result in the third row with the description "Difference"?

 

Total per file A321
Total per file B123
Difference198

 

And is there formatting in Alteryx like in Excel? For example, to have the different amount with a line on top and double line at the bottom

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@Carol_Chiu 
Let do it one by one so perhaps I can get two accept mark.

1205-Carol_Chiu.PNG

Qiu
21 - Polaris
21 - Polaris

@Carol_Chiu 
As far I know, Alteryx is for data processing not for visualization so only having basic formatting functions.

There are something can be done by Table Tool but can not exactly get what you need, I am afraid.

1205-Carol_Chiu-1.PNG

Carol_Chiu
6 - Meteoroid

Thanks. It worked.

Labels
Top Solution Authors