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?

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

keith2598 Rookie Asked on February 19, 2020 in Training.
Add Comment
2 Answers

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.