Data Model has wrong calculation

[masplin]

Has anyone ever come across this with the 2010 add-in as quite disturbing. I have come across this a few times recently where the contents of a cell in the powerpivot window for a calculated column is just plain wrong. Mostly it is something as simple as adding 2 other calculated columns together. If I add a "+0" to the formula it recalculates correctly and then I remove that and the answer is now correct.

however this means I just can't trust any of the output. I'm really worried I may have this issue in multiple places, but only come across it by fluke.

Mike

 

[Kasper de Jonge]

here you go

https://www.dropbox.com/s/1tn1j0u877fv22k/INO_Data_Sep14error.xlsx?dl=0

Thanks Mike

Hi Mike, that looks rather bad. I get a file not found, can you share it so I can get someone to look at it?

Thanks,
Kasper

 

[masplin]

sorry scott advised me to take down the link as it contains all the companies financial data!!!! I'll PM it to you

 

[Kasper de Jonge]

Thanks, that makes sense

 

[masplin]

I guess no one has an ideas? I had another bizarre one today where the formalua had a text lookup from a filter on another table. The field was empty and I knew it had an answer. I copied the formula into a new column and it correctly calculated. I could not get the origninal calculated column to get the correct answer depsite trying manual calcualtion etc. i ended up deleting the column and reanming the new column. This is really worrying as i have no idea what oher errors there are.

Is my only answer to rebuild from scratch? The issue is how do you know when you have a corruption? I am very reluctant to rebuuild in 2013 as the model is so painful to work with as it in insisits on reclculating everytime you change anything. I do have the excellent OLAP Pivottable extensions addin that allows you to disable the pivot refresh, but this doesnt work when you are creating lots of new measures. Is 2013 any less likely to have these incomplete/incorrect calculation errors?

Thanks

Mike