I think that everything is in order in FM regarding links.
The problem that i have is that in a simple list the amount column repeats itself with the same number that is the total of the lines.
Also if a create a crosstab and throw the amount inside i get the same number also...
If i change the aggregate property to NONE for the amount in the list i get the correct results.
Crosstab remains to show the totals. Please see the pic.
I am sure it is a newbie wuestion with problems in FM but i cant figure out what...
Greetings
At first glance, I would suggest that you investigate the possibility that you have double counting.
You would need to make sure where the fact grain is. You need to fix up your determinants.
And just to confirm, this is cod data, not real, and your choice of company was just a coincidence?
http://www.cognoise.com/index.php/topic,24030.msg74923.html#msg74923
Quote6. Security of client data. Please do not attach or link to confidential or sensitive documents provided by your client or employer. If you are describing a report you want to author, do not post an actual report output containing sensitive data you have been given to replicate. I know this seems obvious, but surprisingly it has happened.
Thanks! I missed the name.. Removed the pic.
The way i think i fixed it is that i disables auto group and summary from the query. Is this the correct way or i have something missing/wrong in fm?
Well, I still think it's a double counting issue.
Could you explain in a bit more detail the steps you took to investigate the issue please. In particular, could tell us the results of your investigation into the validity of the relevant determinants, the fact grains etc.