Mixed Granularity many to many eliminating wanted duplicates!

[#1]

Hello-

I have created a mixed granularity data model (budget vs actuals).

The budget numbers are coming out fine, but the actuals are not counting duplicate values (e.g, if the same amount of salary was charged twice in a month for a biweekly employee, it's eliminating that duplicate value from the total expenses).

Any ideas where I should start looking for the problem?

Thanks!

[sunny_talwar]

Can you share your script to have a look at it? Without looking at the script, it would be hard to troubleshoot this one.

[#3]

Well, Sunny, I just learned a GREAT BIG LESSON.  I was pulling data from a spreadsheet all this time and the underlying spreadsheet data was messed up.  My model is clean!!!

thanks for helping!

Camilla