This content has been marked as final. Show 3 replies
Can someone explain to me how to calculate a field in the script from two fields in a table that is the result of left-joining to load statements?
Here is the simplified script
Left Join Load
What is the next step to add to this table the field InvoiceValueUSD=InvoiceValueEuro*ExchangeRate ??