This content has been marked as final. Show 1 reply
you cannot directly calculate the percentage for each order with the computation features of the IR. You would need to have the total over all orders as additional column in each record to build a computation on it. The IR does not support this out of the box.
But fortunately Oracle supports analytic SQL. Using this feature your request can be solved with a little extension to the SQL statement. Try this:
The sum(order_total) over () does the trick!
select order_id, customer_id, order_total, order_timestamp, user_id, sum(order_total) over () sum_total from demo_orders