Tuesday, May 28, 2019

Create a Formula to Calculate the Days Beyond the End Date or Ship Date in a Sales Order Saved Search

Add the following in the Results tab > Columns sub tab:

·        Field = Formula (Numeric)

·        Formula = case when {enddate} is null then(trunc({today}-{shipdate})) else (trunc({today}-{enddate})) end

Note: This formula is tested using a Saved Searchwith Criteria Type equals to Sales Order.

No comments:

Post a Comment