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