Riskonnect Report: Calculated Field based on difference between two dates - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Steve FretwellSteve Fretwell 

Riskonnect Report: Calculated Field based on difference between two dates

I wish to create a calculated field in a report that flags when the difference between two dates is greater than a set number of days.  Ideally, the report would only show where this is true, but it would be helpful just to flag this.

I've tried using a simple DATE_1 - DATE_2 = RESULT doesn't show the difference is a calculated field, regardless if the result is 0 or greater than 0.
Best Answer chosen by Steve Fretwell
Eric PraudEric Praud
Instead of a summary formula, create a row level formula, you'll see an option when clicking the arrow pointing down by the fields section:
User-added image

All Answers

Eric PraudEric Praud
Hi Steve,

If you're creating a row level formula, you could go with one that returns a number:
DATE_1 - DATE_2
You can now filter your report with formula gretaer than x

If you're going to reuse it, create a formula field on the object instead and use it for the filtering
Steve FretwellSteve Fretwell
Eric, 

Thanks for such a quick reply :-).  I'm not sure what you mean by row level formula. 

I've created a Summary Formula "Edit Summary-Level Formula Column" when I edit.

Steve
Eric PraudEric Praud
Instead of a summary formula, create a row level formula, you'll see an option when clicking the arrow pointing down by the fields section:
User-added image
This was selected as the best answer
Steve FretwellSteve Fretwell
Eric,

Fantastic!!  Perfect solution. 

Many Thanks

Steve
Eric PraudEric Praud
Great!

Can you please select the answer that helped you as best answer so it closes the question and others can refer to it if they face the same issue?
After all, that's what this community is about, helping each other :)

Thanks