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
User | Count |
---|---|
109 | |
89 | |
77 | |
54 | |
40 |