Hi Team,
Can anyone help me on below scenario:-
I have same order number for two amount say for example
Order Number 121 has two transaction $ 100 Debit and $ 100 Credit. Now, Without using the summarize tool how can we offset this two amount.
That depends on the format of your data
@cmcclellan
Didn't get you
I have multiple transactions from salary and I have to figure out the pair which is sum is not equal to zero
@Amy123
I didn't get the whole idea but see if this workflow helps you (at least to identify who's paired and who's not)
@AZuc
No..this is not i am looking.
usually on Salary ID level some amount could be net off that i highlighted in Pivot column..
@Amy123 see if this one works for you
Can you test this data..
try this.
but i not understand why still positive even it original is negative. (you can add a abs function later.)
thanks @AZuc, after i open your workflow, only realise i do too much 😂
after:
before:
