Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Get a report which matches multiple criteria — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Get a report which matches multiple criteria

Received Response
10
Views
1
Comments
edited Jan 3, 2018 9:58PM in Reporting & Analytics for B2C Service 1 comment

Content

I want to get a report of Organizations which have expired on their support contract (SLA instance) last quarter.  I do not want the org to show up if they have an active SLA.  I cannot seem to exclude the Org from the report if they have an active SLA and only include them if they have an SLA that expired in the qtr.

Because the SLA Instances table has a record for every SLA, when I run a report to get expired, it looks only at the Exp_date field but doesn’t take into account the other records which are active.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!