Location: The Official Oracle Wiki

Discussion: How to sum up the amount when there are a few product level using BIP?Reported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 1 post

yee.yen.chin
How to sum up the amount when there are a few product level using BIP?
Jul 19 2009, 10:53 PM EDT | Post edited: Jul 19 2009, 10:53 PM EDT
The version of the BI Publisher we are using is 10.1.3.4
There are many product line items . For each line item, there are many attributes. For each attribute, there is price attched with it. In this case, how can we sum up the amount by attribute then later group by each line item.

For eg.
Product Line Item A - Attribute A - Price A
Product Line Item B - Attribute B - Price B

--------------------------------------------------------------------------------
Total amounts of Attribute A + ATrribute B = Price A + Price B

Question: How do you write to sum up Price A and Price B?

Currently we are able to achieve the total amount for one product line item only ie. Price A .
If there are more than one product line item how are we going to achieve the results. Do you find this valuable?    
Keyword tags: BI_Publisher BIP sum

Sign in to be the first to reply.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Oracle BI Publisher