Display deals where the "actual close date" is later than the "expected close date"

[Jay-Z]

Hello all,

We’ve added “Target POV end date” and “Actual POV end date” to our sales deals in order to keep track of how often prospects get extensions to their trial periods of our software.

However, as you can see from this screenshot, it’s only possible use absolute date values for the “is after” option in a report filter.

Is it possible to implement relative values in report filters?

Thanks in advance for your assistance on this topic.

[karstenkoehler]

Hi @Jay-Z,

You should be able to specify that one date must before the other in a deal list: Create segments

Once you have the deal list, you should be able to filter the report by list membership.

Another approaches would be a custom calculation property that checks whether one date is before the other: Create calculation and rollup properties

Have a look and let me know if you have any follow-up questions!