Account Reconciliation - get the total value of multiple transactions to match one payment
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
EmilyXu0101
5 - Atom
‎01-13-2023
02:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Alteryx Community,
I am new to Alteryx. I get stuck when I create workflow to match multiple transactions with one payment.
Is there any tool or formula can help to identify the total value of payrun 1-4 = payment 1, payrun 5-7 = payment 2? Then the output would be the rows which can't match with payment.
Thanks
Labels:
- Labels:
- Output
1 REPLY 1
ShankerV
17 - Castor
‎01-13-2023
03:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @EmilyXu0101
Please find the expected output.
Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.
If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!
Many thanks
Shanker V
