0

Sum Qty in selected field for each Value in Arrray

HI , 

i have a formula field that has an Array of product code numbers 

i have a table with orders 

i would like to select the Order table and sum the qty on order for each product in the Array Field

any idea how to do that?

3 replies

null
    • BugTrapper
    • 4 yrs ago
    • Reported - view

    Let sum:=0;

    For i in ArrayProductCodeNumbers do

    sum:=sum+first(select orders where CodeNumber=i.CodeNumber).Qty

    end

    • Ppc
    • titanium_fish
    • 4 yrs ago
    • Reported - view

    HI Tahnk you for the reply , Still getting some sort of error

     

    sku snip

    • BugTrapper
    • 4 yrs ago
    • Reported - view

    where ' Sheet SKU #' = i).Qty

Login to reply

Content aside

  • 4 yrs agoLast active
  • 3Replies
  • 774Views