Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use BETWEEN function in Discoverer report level calculation?

704160Jun 24 2009 — edited Jul 2 2009
Hi,

I have requirement in discoverer report to:

All part_numbers between SDK00 and SDK99 should have calculation (Pay_amount+100)

SQL for that is:: PART_NUM between 'SDK00' and 'SDK99'

*How can i get the BETWEEN function in Discoverer report-level Calculation in Discoverer Desktop or Discoverer Plus?*

Thanks in advance,
Gayatri

Edited by: gayatri chodankar on Jun 24, 2009 8:32 AM
This post has been answered by Michael Armstrong-Smith on Jun 24 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 30 2009
Added on Jun 24 2009
#business-intelligence-applications, #business-intelligence-foundation, #discoverer
15 comments
1,647 views