Invoice Tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
Needed your expert help on how to process below table data onto the reporting text on alteryx without modifing the existing data what is abailable on the t reporting text tool (currently it contains some static and neeeded to added below table).
Kindly note - am trying to build a logic ro build a invoice comparision coming from different souces and needed to add all data on reporing text tool.
Type | Assets Under Custody | Basis from | Basis To | Value | Calculated Amount |
AUM | 1827 | 0 | 5000000000 | 0.004 | 0.07 |
AUM | 1827 | 5000000000 | 10000000000 | 0.0035 | |
AUM | 1827 | 10000000000 | 99999999999 | 0.003 | |
AUM | 637 | 0 | 99999999999 | 0.00125 | 0.01 |
Due to system restricction am not able to add the scresn shot of thw workflows, kindly help me with a solution.
Thanks,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Myusrename001 struggling a bit, what form are the inputs?
Highlevel, I would suggest joining the two data sets using the join tool, and then using the formula tool to calculate any variances and then formatting it how you want the output
