How to use aggregate functions in where select like
while select inventDim
group by inventDim.wMSLocationId , inventtable.ItemId ,
where inventDim.wMSLocationId == wmslocation.wMSLocationId
join inventSumExtra where inventDim.inventDimId == inventSumExtra.inventDimId
join inventTable where inventSumExtra.ItemId == inventTable.ItemId
{
info(strfmt("Sum Total Quantitiy %1",sum(inventSumExtra.TotalOrderQty)))
}
i am getting error on sum(inventSumExtra.TotalOrderQty).how to use sum() in this query inside the loop.Is this possible or not
*This post is locked for comments
I have the same question (0)
