Home > Default > Aggregation not showing correct results in 10g

Aggregation not showing correct results in 10g

November 30Hits:0
Advertisement
Hi,
We have created a calculated column in BMM layer as x=Sum(Amount)/sum(Distinct Members).
In the report, individually it is showing correct results but when we are calculating "Total By" it is showing wrong total.This is because of while calculating totals it is taking the formula as x=Sum(Amount)/sum(Members).
Aggregations are kept as default for all the columns in the report .
Please help me to solve this issue.

Answers

For this calculated column set aggregation level as sum.

Read other 2 answers

Tags:

Related Articles

  • Aggregation not showing correct results in 10gNovember 30

    Hi, We have created a calculated column in BMM layer as x=Sum(Amount)/sum(Distinct Members). In the report, individually it is showing correct results but when we are calculating "Total By" it is showing wrong total.This is because of while calc

  • Urgent-Calc needs to run twice for correct result.November 30

    Hi There, I have a hierarchy in account like this Account Account1 dynamic calc      Account11 never share           Account13 never share Account2     dynamic calc Account21 never share Balance In another hierarchy inside account I have following me

  • Log application query not showing correct resultsOctober 11

    Hi, We are running Dataguard (DG) in our production environment. EBS 11.5.10.2 and DB 10.2.0.4. Every morning we run the following query on both primary and standby to confirm that the logs are being transported and applied to the standby: select seq

  • TABLE(CAST()) function not returning the correct results in few scenarios.October 11

    I am using TABLE(CAST()) operation in PL/SQL and it is returning me no data. Here is what I have done: 1.     Created Record type CREATE OR REPLACE TYPE target_rec AS OBJECT target__id          NUMBER(10), target_entity_id NUMBER(10), dd           CH

  • Report not showing correct resultsOctober 11

    I am new to SSRS.  Using SQL 2008, Visual Studio 2010 shell. I have a stored procedure that when I execute it through SSMS, it returns the correct results.  However, when my report runs through SSRS (using the same stored procedure).  I get inconsist

  • Date difference is not showing the correct result for date intervalNovember 30

    Hi Expert,                 I've created two formula variable one for PO date and another for GR date while i am taking the date difference of GR and PO date for single PO date selection it showing me correct result , but while i am taking the date in

  • Query not giving the correct resultNovember 30

    select Project_id, contractno from elf_transactions where(rtrim(contractno),rtrim(project_id)) not in (select rtrim(contractno),rtrim(projectid) from contract_proj where report_month='1-May-2007' ) when I m firing this query, it is not giving correct

  • VL06I Inbound delivery monitor not showing correct resultsNovember 30

    Dears, We are creating inbound deliveries on the basis of POs and creating GR via MIGO after eliminating movement type in line item catageory by using SPRO. For monitoring we would like to use VL06I but its not showing correct results. Can anyone gui

  • % Change is not giving correct results.November 30

    Hi, I am using Ago Function to calculate Current month cx count , previous month cx count, present month acct count, previous month acct count and in the report parameter selecting Reporting Month as DEC 09. The results are coming perfectly fine... b

  • Problems with EVGET not Returning Correct ResultsNovember 30

    We have several reports with EVGETs that are not working.  It seems to be limited to gets on a particular datasrc when getting members at the base level.  Here is an example. Application: Budgeting Deptid: D_07104 Account: A_612080 Product: P_070040

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.529 s.