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,
@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