Forum Discussion
PowerPivot not returning the the correct value?
I'm writing a simple IF formula and powerpivot is not returning the correct value. Formula: =RELATED(CostCenterLookup[Adjusted Cost Center]) I'm using a related table that will not have a value for...
Hi Gpippin8,
It should work. I guess there could be some invisible chars in the CostCenterLookup[Adjusted Cost Center]. Can you share the file?
Best Regards,
Dale
I can't use that file but I will find a dummy database torecreate the issue and share the file. The weird thing is that the formula works on 1 computer, but it does not work on any other computer. We have tried uninstalling and reinstalling PowerPivot and Excel and Miscrosoft Office. Non of that has worked. I'm at a loss of what to try next so I'm hoping someone else has had this issue and fixed it.
We are funning Excel 2010.
I wont be able to post anything until Monday to allow you to access the issue.