You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!

Facing Issue in calculating percentage for an Analysis in OTBI

Received Response


We are trying to create a custom analysis to calculate the month wise percentage of delivered amount being early received including tolerances. We have calculated delivered amount and early received amount as a new calculate measure in the analysis but when we are trying to calculate the percentage of Delivered amount being early received using these two calculated measures, it is throwing an error. Could anyone help us with this issue?

Content (required):

Below are the formulae we used to achieve the same:

Subject Area: Receiving-Purchase Receipts Real Time

Delivered Amount: SUM("- Purchase Receipt Line Details"."Delivered Quantity"*"Purchase Order Lines Details"."Price")

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!