Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Invoice Tool

Myusrename001
8 - Asteroid

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. 

 

TypeAssets Under CustodyBasis from Basis ToValueCalculated Amount
AUM1827050000000000.004                          0.07
AUM18275000000000100000000000.0035 
AUM182710000000000999999999990.003 
AUM6370999999999990.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,

 

 

 

1 REPLY 1
aatalai
13 - Pulsar

@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

Labels