Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
It seems like you are not following the the correct syntax for using the group by function. You have to use an aggregation function like max, sum, count....etc. for using the group by function.
if you are just using a normal division or addition, group by clause is not needed.
Why are you using group by. It is not necessary unless you want to do aggregations in your script.
Try
Load ItemID, CurrentStock, CurrentStockValue, CurrentStock / CurrentStockValue as ItemCost
Resident Stock ;
OR (if you want to aggregate)
Load ItemID, sum( CurrentStock), sum
(CurrentStockValue) , sum(CurrentStock) /sum( CurrentStockValue) as ItemCost
Resident Stock Group By ItemID;