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?

Anyone know how to create a formula to capture the vairance between 2 columns in a saved search

Rookie Asked on February 19, 2020 in Training.
Add Comment
2 Answer(s)

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.

Beginner Answered on February 20, 2020.

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

on February 20, 2020.
Add Comment

I don’t think you need anything fancy for this. Just make a numeric formula column whose formula is {transferorderquantityshipped} - {transferorderquantityreceived}

Intermediate Answered on February 25, 2020.

Yes I figured this out last night and did exactly this.  It worked perfectly.  Thank you for the reply!

on February 25, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor