OraFAQ Forum: Reports & Discoverer » SUM instances between 2 values

Home » Developer & Programmer » Reports & Discoverer » SUM instances between 2 values (OracleBI Discoverer Version 10.1.2.55.26)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SUM instances between 2 values [message #657755]

Mon, 21 November 2016 11:01

hogsrul
Messages: 1
Registered: November 2016
Location: Atlanta, GA

Junior Member

I have a Count distinct Unit Price column (Contains all of the different prices paid for a product during a specific time period) and I want to count the number of times Unit Price falls between 2 values for a weekly time frame. These two values are specified items with a static value in each column for same time period.

Example:

Dist Count Unit Price = 50, of those 50 unique values, how many of them fall between Net Cost and Sales rep Cost?

Any help would be appreciated.

Report message to a moderator

Re: SUM instances between 2 values [message #657762 is a reply to message #657755]

Tue, 22 November 2016 01:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Generally speaking, that would be

select count(distinct unit_price)
from your_table
where some_column between net_cost and sales_rep_cost

"net_cost" and "sales_rep_cost" can be report items; in that case, precede their names with a colon (:).

Report message to a moderator

Previous Topic:	Generate SAVE disabled PDF - ORACLE Reports
Next Topic:	format trigger ' M_4 ' references column ' CF_SEG ' at wrong frequency

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 15:34:36 CST 2024