Forum Discussion

BrianPierron's avatar
BrianPierron
Qrew Trainee
7 years ago

formula checkbox help needed

I'm tracking when orders are received and i need a formula checkbox to check it self if the quantity of the product ordered is equal the sum of multiple numeric fields that are used to track the quantity of smaller shipments received. This was my first formula attempt that does not work: If([Quantity Ordered]=Sum([Quantity Received]+[Quantity of Remaining Items Received]),"yes,"No"). Does anyone have any better suggestions for me? 
Formulas and functions
  • KevinSlider's avatar
    KevinSlider
    Qrew Trainee
    7 years ago
    If([Quantity Ordered]=Sum([Quantity Received],[Quantity of Remaining Items Received]),"Yes,"No")

    I think the Sum function requires this format Sum(X,Y,Z)
    Let me know if that helps, using the comma delimiter.