Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
[link]:
SQL SELECT t0."estp-blank-l",
t0."estp-blank-w",
t0."k-est-code",
t1."estrc-coverage",
t1."estrc-weight-qty",
t1."estrc-usage",
t1.kinkcode,
t2.JobCode,
t3.OrderedQty
// num((((((((([t0.estp-blank-l]*[t0.estp-blank-w])/1000)/1000)/100)*[t1.estrc-coverage])*t3OrderedQty)*[t1.estrc-usage])/1000)) as f
FROM
PUB.estprofile as t0,
PUB.estrcoat as t1,
PUB."PV_Job" as t2,
PUB."PV_JobLine" as t3
where t0."k-est-code" = t1."k-est-code"
and t0."k-est-code"=t2.EstCode
and t2.JobCode = t3.JobCode;
Yep was a issue on the script line.
((( (((t0."estp-blank-l"*t0."estp-blank-w")/1000000)*t1."estrc-coverage")*(t3.OrderedQty+2500))*t1."estrc-usage")/100000) as "Calculated Ink Kg"
now working.
Hey Brett,
By just looking at the formula, it seems like you are missing "." in "t3OrderedQty". Maybe try to change it to "t3.OrderedQty" in order to see if it works.
Hope this helps.
Yep was a issue on the script line.
((( (((t0."estp-blank-l"*t0."estp-blank-w")/1000000)*t1."estrc-coverage")*(t3.OrderedQty+2500))*t1."estrc-usage")/100000) as "Calculated Ink Kg"
now working.