Value cannot be determind in calulation

[Heather12345]

Hi All,
I'm fairly new to powerpivot but have done a fair bit of excel/access before so thought it would be ideal for what i need!
However trying to do my first calculation which is fairly simple
='OF report'/'OF report'[Customer Ops]/'EST Lost Sales'[WUs Failed]

it errors saying "the value for column Customer Ops in table OF cannot be determind in current condition" This makes me think its something to do with the data type however it both tables they are Decimal number

I think it's probably something simple but no idea what!
Any advice much appreciated

 

[miguel.escobar]

Hey Heather and welcome to the Powerpivot world!

Question, are you trying to create a measure or a calculated column? is there any way that you can upload a copy of your workbook or recreate your model with dummy data?

The error that you got it's basically saying that Powerpivot can't determine your current row context in that formula. So, in order to give you a good suggestion I'd need to see that 'OF report' table