Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
function Get_num_in_array(MrpKeyArray,QtyDemandArray,QtySuplly)
a=split(QtyDemandArray,",")
b=QtySuplly
c=split(MrpKeyArray,",")
For x=0 to UBound(a)-1
if QtySuplly => a(x) then
QtySuplly = QtySuplly - a(x)
ResultDemandQty = ResultDemandQty & a(x) & ","
resultDemandKey = resultDemandKey & c(x) & ","
else
ResultDemandQty =ResultDemandQty & QtySuplly & ","
resultDemandKey = resultDemandKey & c(x) & ","
end if
next
Get_num_in_array = resultDemandKey & ResultDemandQty
End function
plaese help me.
Thanks in advance
Hi,
It seems to be working for me.
Check the attached qvw.
Can you send a sample qvw?
Fernando