We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Subtracting Values

Taylor_Beckner
5 - Atom
‎05-08-2024 05:23 AM

Hello,

 

I have a dataset currently as

CompanyPeriodTotalAccountSystem
BPS122024512.68Non-842System 1
BPS12202411320.57842System 2
BPS122024891.08Non-842System 2
BPS12202411320.57842System 1

 

I would like to subtract the accounts that match to find the difference of a balance. For example:

System 1 Non-842 Total - System 2 Non-842 Total = Difference

512.68 - 891.08 = -378.4

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
usmanbashir
11 - Bolide
‎05-08-2024 05:58 AM

@Taylor_Beckner - Please see attached. Hope this helps!

Subtract_20240508.yxmd
Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All