Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Error when performing a multiplication on a calculated measure in OTBI

Summary:

Hello,

When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve.

Content (please ensure you mask any confidential information):

These are the 2 fields i want to multiply:

I tried three different ways:

"Purchase Order"."Purchase Price"*"Purchase Order Measures"."Ordered Quantity"

CAST("Purchase Order"."Purchase Price" AS NUMBER) * CAST("Purchase Order Measures"."Ordered Quantity" AS NUMBER)

SUM("Purchase Order"."Purchase Price") * SUM("Purchase Order Measures"."Ordered Quantity")

What is the correct way to calculate this type of data?

I need a column that contains the multiplication of the two data

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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