RE: Anyone know how to create a formula to capture the vairance between 2 columns in a saved search
In my saved search I want to only capture what has not been received. Is there a formula I can add to do this?
Field: Formula(Numeric)
Formula: SUM({quantity})-SUM({quantityreceived})
Summary type: Maximum
You may need to check the field names, as it’s not a document type we use, so I couldn’t test exactly.
Thank you for the help. I think I need to change my results a bit as it did not work. I really appreciate your help on this. In my screen shot it just shows the 2 fields I added in the results for the sums. the records are pulled from transfer orders
