Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to do a preceeding load from two resident tables in the script.
"Quantity" in TableA,
"360 dayvel." in Table B.
I wanna do the calculations:
If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8 as [0-8WOH]
Anyone can give me hints.
do you mean apply a join and then get this calculation ?
something like
one:
load
fields
from your table
join
load
fields
from your table two;
load
*,
calculations
resident one;
drop table one;
Table17:
LOAD SKU#,
Sum([Qty On Hand]) as [Total Quantity]
GROUP BY SKU#;
LOAD SKU#, [Qty On Hand]
Resident SKORT;
Join(Table17)
LOAD *
Resident Table16;
Table18:
LOAD *,
If(([Total Quantity]/([360-day Velocity]/52))>=0 and ([Total Quantity]/([360-day Velocity]/52))<=8, [360 0-8 WOH])
Resident Table17;
DROP Table Table16;
Lemme knw whether this is fine?
yes, that should work, assuming that join between table 16 and table 17 is correct
please post some sample data and your exprected result.
thanks
regards
Marco