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
20 - Arcturus
20 - Arcturus

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

1205-Carol_Chiu.PNG

Qiu
20 - Arcturus
20 - Arcturus

@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