Author Topic: Adjusting aggregation level in FM  (Read 185 times)

Online priya1988nath

  • Full Member
  • ***
  • Join Date: Dec 2017
  • Posts: 5
  • Forum Citizenship: +0/-0
Adjusting aggregation level in FM
« on: 12 Dec 2017 09:50:52 am »
I have a table “Table1” .While aggregation to the Column “Name” and "Name_Key",my calculated field shows wrong values
“Calculation” Column is based on “Amount” and “Expense” and based on aggregation level.
Calculation =Amount –(total of Expenses based “Name_Key” column)
The results should be like below. But it’s not showing the calculations as expected. I hope ,I made you guys understand the issue.
 

I have a table “Table1” .While aggregation to the Column “Name”.my calculated field shows wrong values
“Calculation” Column is based on “Amount” and “Expense” .
Calculation =Amount – (total of Expenses based “Name_Key” column)
The results should be like below. But it’s not showing the calculations as expected. I hope ,below example will help in understanding the issue

Name_Key   Name   Amount   Expenses   calculation
1            A                10         10           0
2            A                10         15          -5


Name_Key   Name   Amount   Expenses   calculation
1            A               10        25     -15

Thanks





Offline Invisi

  • Community Leader
  • *****
  • Join Date: Sep 2016
  • Posts: 233
  • Forum Citizenship: +6/-3
    • Invisi - Vision on Information
Re: Adjusting aggregation level in FM
« Reply #1 on: 03 Jan 2018 07:37:48 am »
Based on your example, my first guess is that this key is missing in your list. Since it's missing, it aggregates on the Name, which is only 'A'. It also seems that the Amount column is not seen as a numeric value. If it is a normal numeric value with a normal aggregation (e.g. total / sum), the value in your second list should be 20, not 10. What kind of aggregation is on that column?
Few can be done on Cognos | RTFM for those who ask basic questions...

 


       
Twittear