For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hi,
EXAMPLE: We have a report that has a calculated column of "Total Time" (sum (......)), and another calculated column of "Total Quantity" (another sum (......)).
We want to show the "TOTAL AVERAGE" that is Sum(TotalTime) / Sum(Total Quantity). This is the calculation of two separate columns (that's why I can't use the standard "average" option).
I have the expresion to calculate it, but I don't know how to show it just in one output (not a column, because it would show in every record.). Is there a way?
I tried to put in in a Variable & show it in a Text Field, but the Text Field is showing the expresion, not the calculation. I am attaching you an image.
Can you help me?
Thanks in advice.
David
Comment
The calculation possible at the report footer are limted, you can not add your own.
Be the first to rate this
|
Sign in to rate this