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
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?