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

Sumifs/Countifs Function?

edited Jun 2, 2017 3:46PM in Reporting & Analytics for B2C Service 2 comments

Content

Hi there! I am trying to count something in a report that meets criteria in two different text fields. For example, the formula I would use in Excel would be: countifs(A:A,"Agent Name",B:B,"Fiscal Week") and it would count how many rows have both the specified agent name and the specified fiscal week. Is there a way to do that in Oracle? I've been playing with some of the functions for a while, but I can't figure it out. Thanks in advance!

Version

RightNow Service Cloud

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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