Hi Gurus,
we have a requirement to create a custom metric in answers. This new metric is the division of other two metrics.
Issue is when i create this new metric and pull the other 2 fields into the f(x) and set aggregation content to average , obiee shows incorrect values.
Third metric is a simple division of first metric (the numerator, its a double and a dollar amount field) and second metric (denominator, its an integer and a simple "no of orders" field).
I gave the correct aggregation rule, but showing wrong answers. I even tried "cast as double" and "avg" aggregation rule within the F(x) of new metric. Still no luck.
Not sure what went wrong. Also the first 2 metrics are calculated fields themselves with "sum(max( fact column by some dimensions )) " kind of calculation with their aggregation rule as sum.
can any one interpret this. appreciated. Thanks.
Sorry forget to mention, all the 3 metrics are being created in answers, not RPD. Unfortunately we don't have the option of moving this work to be done in RPD.