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

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

1 REPLY 1
usmanbashir
11 - Bolide

@Taylor_Beckner - Please see attached. Hope this helps!

Labels