Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Calculating wrong values in Subtotals.

Received Response
41
Views
3
Comments
saipriya vangara
saipriya vangara Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

As I calculate the subtotals in the tabular report for which I work as a BI developer, the calculation is automatically producing incorrect results.

image.png


Answers

  • Clare Murtagh - new
    Clare Murtagh - new Rank 5 - Community Champion

    what does your calculated field state and what are you expecting to see? c/g *100 looks correct? unless you want to show percentage increase?

  • saipriya vangara
    saipriya vangara Rank 1 - Community Starter

    At times, the OAC automatically produces the incorrect calculation.

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited February 2024

    Hi Saipriya,

    This forum is not for product Oracle Analytics Cloud OAC (a Paas). It is for product Oracle Business Intelligence (OBI) (suite Enterprise Edition EE) inside Oracle Transactional Business Intelligence (OTBI) inside Oracle Fusion Cloud Applications (a SaaS). OAC is a different more recent product using a different technology Data Visualisation (DV) (but also has OBIEE in it for backwards compatibility).