Subtracting Values

[Taylor_Beckner]

Hello,

I have a dataset currently as

Company	Period	Total	Account	System
BPS	122024	512.68	Non-842	System 1
BPS	122024	11320.57	842	System 2
BPS	122024	891.08	Non-842	System 2
BPS	122024	11320.57	842	System 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

[usmanbashir · Accepted solution]

@Taylor_Beckner - Please see attached. Hope this helps!