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

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

FILTER Expression

Received Response
17
Views
1
Comments
edited Dec 16, 2019 6:35PM in Oracle Analytics 1 comment

Summary

I am trying to do 2 Rpts. Count and SUM based on a value

Content

I am trying to create two reports. 

Show SUM(XPaidAmt) where XPaidAmt <= 10.00

Show Count(XPaidAmt) where XPaidAmt <= 10.00

Both grouped by XPayDesc

Sum( X_PAID_AMT = {"<=10.00"}>} X_PAID_AMT)

Count( X_PAID_AMT = {"<=10.00"}>} X_PAID_AMT)

Suggestions?

 

Version

18 , Cloud

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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