Table Links and Sums in Scripts, Create new field.
Was trying new ways to load data from different tables then add. Below is a script which successfully loads the data but i cant manage to calculate the new field "F". The calculation is required in the load statement as i want to sum the results in presentation. Any suggestions, thanks Brett
SQL SELECT t0."estp-blank-l",
// num((((((((([t0.estp-blank-l]*[t0.estp-blank-w])/1000)/1000)/100)*[t1.estrc-coverage])*t3OrderedQty)*[t1.estrc-usage])/1000)) as f